Ask Question, Ask an Expert

+1-415-315-9853

info@mywordsolution.com

Ask Statistics and Probability Expert

Regression with confidence interval

Open up Excel and Click on Data Analysis

Click on Regression

Input the Y values in the Y range & the X values in the X range

Make sure the confidence level box at 95%.

Verify the residuals box.

What information is provided?

Family

Weekly Expenditure On Recreation (Y)

Weekly Income (X)

1

90

900

2

60

800

3

45

600

4

70

650

5

30

300

6

40

350

7

50

400

8

55

700

9

85

950

10

75

700

11

90

800

12

70

750

13

60

500

14

40

300

15

25

250

16

65

700

17

60

600

18

50

450

19

35

250

20

35

200

ex of what information should look like:

Data:  

Firm I

Annual Dividend (X)

Price(Y)

1

13

115

2

4

45

3

12

100

4

5

50

5

6

55

6

8

85

7

3

40

8

4

50

9

5

45

10

7

70

SUMMARY OUTPUT

Regression Statistics

Multiple R

0.978902011

R Square

0.958249147

Adjusted R Square

0.953030291

Standard Error

5.652649783

Observations

10

 

ANOVA

 

df

SS

MS

F

Significance F

Regression

1

5866.880403

5866.880403

183.6129

8.45093E-07

Residual

8

255.6195965

31.95244957

 

 

Total

9

6122.5

 

 

 

 

 

Coefficients

Standard Error

t Stat

P-value

Lower 95%

Upper 95%

Lower 95.0%

Upper 95.0%

Intercept

15.20172911

4.119924714

3.6898075

0.006132

5.701159537

24.70229868

5.70116

24.7023

X Variable 1

7.507204611

0.554021622

13.550382

8.45E-07

6.229627634

8.784781588

6.229628

8.784782

RESIDUAL OUTPUT

Observation

Predicted Y

Residuals

Standard Residuals

1

112.795389

2.204610951

0.413672016

2

45.23054755

-0.23054755

-0.043259819

3

105.2881844

-5.288184438

-0.99227209

4

52.73775216

-2.737752161

-0.513710346

5

60.24495677

-5.244956772

-0.984160874

6

75.25936599

9.740634006

1.827727338

7

37.72334294

2.276657061

0.427190709

8

45.23054755

4.76945245

0.894937498

9

52.73775216

-7.737752161

-1.451907663

10

67.75216138

2.247838617

0.421783232

PROBABILITY OUTPUT

Percentile

Y

5

40

15

45

25

45

35

50

45

50

55

55

65

70

75

85

85

100

95

115

Statistics and Probability, Statistics

  • Category:- Statistics and Probability
  • Reference No.:- M920585

Have any Question? 


Related Questions in Statistics and Probability

An iq test is designed so that the mean is 100 and the

An IQ test is designed so that the mean is 100 and the standard deviation is 16 for the population of normal adults. Find the sample size necessary to estimate the mean IQ score of statistics students such that it can be ...

Three individuals are seated in a room each one of them is

Three individuals are seated in a room. Each one of them is wearing a hat, which may be either red or white. Each of them sees the hats worn by the others, but cannot see his own hat (and in particular does not know its ...

The mean sat score in mathematics is 515 the founders of a

The mean SAT score in mathematics is 515 . The founders of a nationwide SAT preparation course claim that graduates of the course score higher, on average, than the national mean. Suppose that the founders of the course ...

Kindergarten children have heights that are approximately

Kindergarten children have heights that are approximately normally distributed about a mean of 38.8 inches and a standard deviation of 1.5 inches. If a random sample of 21 is taken, what is the probability that the sampl ...

Explain how you would conduct the study in given question

Explain how you would conduct the study in given question as a within-subjects design. Question:- Imagine that you were conducting an experiment to examine the effect of generous role models on children's willingness to ...

A box contains 3 plain pencils and 5 pens a second box

A box contains 3 plain pencils and 5 pens. A second box contains 9 color pencils and 3 crayons. One item from each is chosen at random, what is the probability that a pen from the first box and a crayon from the second b ...

What is the difference between the standard deviation

What is the difference between the standard deviation, standard error of the mean, and standard error of the estimate? Discuss and offer examples.

The premise a few years have passed and your survivor group

The premise: a few years have passed, and your survivor group has grown due to the merger with another group of survivors. You still maintain the position as the intellectual of the group because you are a historian.  Al ...

In this exercise we present a family of algorithms each of

In this exercise, we present a family of algorithms, each of which produces the men's courtship matching, and contains the Gale-Shapley algorithm. Consider the following algorithm for matching men and women. At the start ...

Bob like peggy wants to know if his cookies are special but

Bob, like Peggy, wants to know if his cookies are special, but all he knows are the class average of 21.65 chips per cookie, and his own data for his 10 cookies: 12,14,15,12,12,13,17,15,15,22. Conduct all six steps of hy ...

  • 4,153,160 Questions Asked
  • 13,132 Experts
  • 2,558,936 Questions Answered

Ask Experts for help!!

Looking for Assignment Help?

Start excelling in your Courses, Get help with Assignment

Write us your full requirement for evaluation and you will receive response within 20 minutes turnaround time.

Ask Now Help with Problems, Get a Best Answer

WalMart Identification of theory and critical discussion

Drawing on the prescribed text and/or relevant academic literature, produce a paper which discusses the nature of group

Section onea in an atwood machine suppose two objects of

SECTION ONE (a) In an Atwood Machine, suppose two objects of unequal mass are hung vertically over a frictionless

Part 1you work in hr for a company that operates a factory

Part 1: You work in HR for a company that operates a factory manufacturing fiberglass. There are several hundred empl

Details on advanced accounting paperthis paper is intended

DETAILS ON ADVANCED ACCOUNTING PAPER This paper is intended for students to apply the theoretical knowledge around ac

Create a provider database and related reports and queries

Create a provider database and related reports and queries to capture contact information for potential PC component pro