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.

## Reviews, comments, and love from our customers and community:

This page is having a slideshow that uses Javascript. Your browser either doesn't support Javascript or you have it turned off. To see this page as it is meant to appear please use a Javascript enabled browser.