Link to download the word & excel files, see below one drive link

https://1drv.ms/u/s!AkMGBOrOyDwqilWYpza1y06--nsM?e=gdBysL

BUS255 - Compensation - Linear Regression Analysis

This assignment deals with understanding Excel spreadsheets, basic statistics as well as Charts and Trend-lines.

Marks

Question

2

1.Open the Salesum document, and add functions to calculate the average, Max, Min and Count on rows 18-21 in columns B-E.

2.In Cell B25 type an answer to the following question:Is the average computed in B18-E18 a good predictor of how much a new expense might cost, should we incur a new expense next year?Why or why not?Save the document on your computer as FirstNameLastNameSalesum.xls.

8

1.Continuing with your Salesum.xls document, copy the titles in cells B6:E6 and paste them into cells B9:E9.

2.Select cells A9:E15.

3.Press the F11 key at the top of your keyboard to create a bar chart. (2 marks)

4.Re-arange the chart if required so that the months (Jan-Apr) appear on the bottom axis of the chart, and the Legend contains the expenses. (1 mark)

5.Add a trendline to the chart for the 'Salaries' expense. (1 mark)

6.Right click on the trendline to add the option of showing the trendline equation on the chart as well.

7.Copy and paste this equation into cell B27 of Sheet 1. (1 mark)

8.In cell B28, type the predicted value for August for the salaries expense based on this equation to show your understanding of it.

(1 mark)

9.Given the following equation:

Y = $1,250 +.75x

Calculate the monthly pay for a job with 235 job evaluation points.

Type this equation and resulting value into cell E35. (2 marks)