FINANCE 101 HOMEWORK 3
Complete all of the follow and create a PDF document with all of the required tables, charts, and comments to upload into the dropbox on D2L. Be sure your tables and charts are formatted to fit within the PDF. (You can create everything in one sheet within Excel and print preview to see how it will look as a PDF. Then “save as” and select PDF.)1) The Tall Log Logging Company is scouting out different locations for their next logging site. A random sample of tree heights were taken from each site and is provided in the Excel sheet “TreeHeight”.a. Create an ANOVA table with an alpha level of 0.05.b. Make a statement about if there is a difference between the sites.2) A manager is reviewing the salespersons’ performance to determine the bonus structure. The information is provided in the sheet “Sales” in the Excel file, but is difficult to read and interpret.a. Reformate the table to make it easier to read using the data visualization rules learned in class.b. Create one chart of the data (you don’t need to use all of the information) that shows at least one aspect of the salespersons’ performance. Use the data visualization rules for charts learned in class.c. Comment on the decisions you made in reformatting the table and data included in the chart.3) Create a well-designed scatter plot of the data provided in sheet “HoursWorked” and comment on the relationship between yearly salary and hours worked per week.4) Create a well-designed scatter plot of the data provided in sheet “Education” and comment on the relationship between yearly salary and years of education.