assignment 3 110
Download the file “Fun With Excel Raw Data†Open the file with Microsoft Excel and follow the instructions found with each of the following questions.Print out the results/data, and ensure that you separately provide specific answers to the questions – at the beginning of the assignment, not with the data!DO NOT print out all of the regression data for Question 1, only the basic r-squared and Sig of F information, and the X-Y graph.Be aware, the Mac version of Excel does not allow you to do Pivot Charts, only Pivot tables.So, you will need to use a Windows PC for Question 4, or create the chart separately from the Pivot Table.
for the last question #5 please use “autozone” data from 2013 thru 2018
I uploaded: the description in word and Excel