The spreadsheet entitled COMPUTERS Stats consists of the mean monthly

profiletutor4helpyou
data.xlsx
Home>Mathematics homework help>Numerical analysis homework help>The spreadsheet entitled COMPUTERS Stats consists of the mean monthly

Sheet1

Computer AC (y-bar) PP (x-bar) Person CC (y) HR (x)
1 $347.52 36.3 1 $345.35 36
2 $347.11 37.1 2 $346.25 38
3 $353.43 40.4 3 $351.65 39
4 $342.10 34.3 4 $341.75 35
5 $336.01 35.1 5 $347.00 35
6 $340.10 37.6 6 $288.95 36
7 $336.20 38.1 7 $342.50 38
8 $328.99 32.3 8 $330.35 34
9 $331.21 39.5 9 $326.85 36
10 $340.12 36.6 10 $341.25 36
11 $326.78 32.8 11 $329.55 34
12 $324.52 33.0 12 $327.85 33
13 $279.57 35.6 13 $329.00 36
14 $336.78 37.4 14 $363.50 38
15 $334.03 35.9 15 $341.25 37
16 $327.57 32.8 16 $329.90 33
17 $326.98 31.7 17 $324.50 30
18 $335.43 35.3 18 $338.90 34
19 $329.75 34.4 19 $331.60 34
20 $328.97 35.5 20 $333.80 36
21 $338.99 37.7 21 $343.45 38
22 $274.89 37.4 22 $352.35 37
23 $345.22 36.1 23 $351.95 36
24 $332.91 34.4 24 $289.90 33
25 $289.76 32.4 25 $331.75 32
26 $335.62 37.6 26 $336.75 38
27 $333.27 36.2 27 $341.65 36
28 $298.74 40.2 28 $356.75 39
29 $324.31 27.4 29 $330.95 31
30 $359.96 38.3 30 $360.25 36
31 $355.78 39.1 31 $297.25 40
32 $347.85 36.2 32 $348.95 38
33 $274.89 37.4 33 $324.50 30
34 $345.22 36.1 34 $338.90 34
35 $332.91 34.4 35 $331.60 34
36 $289.76 32.4 36 $333.80 36

Sheet2

Sheet3