Calculations | Mathematics homework help


All the calculations 1-7 must be done delay Excel.

Consider the aftercited postulates from a slender bookstore.

Number of sales inhabitants instituted-----------------Sales (in $1000)

2--------------------------------------------------------------10

3--------------------------------------------------------------11

7--------------------------------------------------------------13

9--------------------------------------------------------------14

10-------------------------------------------------------------18

10-------------------------------------------------------------20

12-------------------------------------------------------------20

15-------------------------------------------------------------22

16-------------------------------------------------------------22

20-------------------------------------------------------------26

x = 10.4-----------------------------------------------------y = 17.6

SD(x) = 5.64-----------------------------------------------SD(y) = 5.34

1. Calculate the average and flag derangement of # of sales inhabitants (x) and sales (y). Discover pattern greatness n.

2. Calculate the interdependence coefficient delay all three modes (covariance mode, z-score mode, and interdependence hireling in Excel).

3. Discover b0 and b1 for the rectirectidirect retrogression pattern delay all three modes (two unanalogous formulas and Solver). Interpret the averageing of b1 of this rectirectidirect retrogression pattern.

4. Calculate Se and SST.

5. Calculate R balance delay twain modes (interdependence coefficient mode and the formula r balance = 1 - SSE/SST). Interpret the averageing of R balance of this rectirectidirect retrogression pattern.

6. Use Retrogression hireling in Excel to discover b0, b1, SSE, SST, r, R balance, and Se.

7. Estimate the sales if the enumerate of sales inhabitants instituted is 8, 13, and 19, respectively.