Northwestern College National Cable & Telecommunications Association Worksheet

Description

Please finish the following worksheet and follow all the corresponding questions. Answer on the excel sheet

1 attachmentsSlide 1 of 1attachment_1attachment_1

Unformatted Attachment Preview

1) According to th National Cable and Telecommunications Association, the average monthly “expanded basic cable rate”has
Year after 1989
Rate
a) Find the equation of the best fitting straight line.
0 $ 15.21
1 $ 16.78
2 $ 18.10
b) Interpret the slope.
3 $ 19.08
4 $ 19.39
5 $ 21.62
c) Predict the avrerage monthly rate in 2004.
6 $ 23.07
7 $ 24.41
8 $ 26.48
d) Predict in what year the rate will reach$50.00.
9 $ 27.81
10 $ 28.92
11 $ 30.37
e) Comment on the accuracy of the predictions in parts c and d.
12 $ 31.58
13 $ 34.52
14 $ 36.59
SUMMARY OUTPUT
Regression Statistics
Multiple R
0.99494
R Square
0.989905
Adjusted R Square
0.989128
Standard Error
0.691363
Observations
15
ANOVA
df
Regression
Residual
Total
Intercept
X Variable 1
SS
MS
F
Significance F
1 609.293 609.293 1274.719 2.32E-14
13 6.213768 0.477982
14 615.5068
Coefficients
Standard Error t Stat
P-value Lower 95%Upper 95%Lower 95.0%
Upper 95.0%
14.60267 0.339871 42.96531 2.13E-15 13.86842 15.33691 13.86842 15.33691
1.475143 0.041317 35.70321 2.32E-14 1.385883 1.564402 1.385883 1.564402
anded basic cable rate”has increased as follows:
Year after 1940
0
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
Federal Debt(in millions of dollars)
50696
1) Create a scatter plot for the data at the left.
57531
79200
2) Write down a linear regression equation. Find r squared.
142648
204079
3) Write down the exponential equation. Find r squared.
260123
270991
4) Using all of this information, what do you think the federal debt will be in 2015?
257149
Explain why/how you got your answer.
252031
252610
256853
255288
259097
265963
270812
274366
272693
272252
279666
287265
290525
292648
302928
310324
316059
322318
328498
340445
368685
365769
380921
408176
435936
466291
483893
541925
628970
706398
776602
829467
909041
994828
1137315
1371660
1564586
1817423
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
2120501
2345956
2601104
2867800
3206290
3598178
4001787
4351044
4643307
4920586
5181465
5369206
5478189
5605523
5628700
5769881
6198401
6760014
7354673
7905316
ederal debt will be in 2015?
Walleye
Length(in.) Weight(lbs.)
14
1
15
1.2
16
1.5
17
1.8
18
2.2
19
2.5
20
3
21
3.4
22
3.9
23
4.5
24
5.1
25
5.7
26
6.5
27
7.2
28
8.1
29
9
30
9.9
31
10.5
Northern
Length(in.) Weight(lbs.)
24
3.9
25
4.4
26
5
27
5.6
28
6.2
29
7
30
7.7
31
8.5
32
9.3
33
10.2
34
11.2
35
12.2
36
13.3
37
14.5
38
15.7
39
16.9
40
18.3
41
19.6
42
21.2
1) Create a scatter plot for the Walleye and Northern data
2) Find a model that best fits the data. Give a reason for y
3) Predict the weight of a Walleye that is 32 inches long.
4) Predict the weight of a Northern that is 50 inches long.
5) Which result are you most confident in? Why?
Walleye and Northern data. The length should be the explanatory variable.
For residential use Beltrami Electric Charges $.086/kwh for the first 500 kwhs and $.067/kwh for all excess useage.
1) Create a spread sheet that could be used by any elctric company to calculate the bill for a residential user.
The kwh values should be changeable as each company may have different rates. The user should be able to enter the kwh v
and your spread sheet should calculate the bill.
be able to enter the kwh values and the usage

Purchase answer to see full
attachment

Tags:
Regression Statistics

standard error

Federal debt

Adjusted R Square

National Cable

Telecommunications Association

User generated content is uploaded by users for the purposes of learning and should be used following Studypool’s honor code & terms of service.