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

One of the most famous labormanagement conflicts took place

One of the most famous labor/management conflicts took place in the 1902 Coal Strike in Pennsylvania. The strike brought the coalmine owner George Baer against the United Mine Workers Union, and led Theodore Roosevelt to ...

Net exports are calculated by subtracting imports from

Net Exports are calculated by subtracting Imports from Exports. Assume Exports and Imports are independent of one another.  If mean exports are $25M with a standard deviation of $3.5M and mean imports are $30M with a sta ...

Tell whether each of the following relationships reflects a

Tell whether each of the following relationships reflects a positive or a negative correlation: a. the amount of stress in people's lives and the number of colds they get in the winter b. the amount of time that people s ...

1 a researcher has developed the hypothesis that teenagers

1. A researcher has developed the hypothesis that teenagers are better able to learn about and remember technological information than are older adults, whereas older adults are better able to remember information about ...

Entertainment software association would like to test if

Entertainment Software Association would like to test if the average age of "gamers" (those that routinely play video games) is more than 30 years old. A random sample of 33 gamers was selected and their ages were record ...

Question to qualify for security officers training recruits

Question: To qualify for security officers training, recruits are tested for stress tolerance. The scores are normally distributed with a mean of 62 and a standard deviation of 8. If only the top 15% of recruits are sele ...

1 compute pearsons r between the life satisfaction variable

1. Compute Pearson's r between the life satisfaction variable and the family income variable in Table 1. Test the r for statistical significance, and draw conclusions about the meaning of the test. 2. Compute a Pearson c ...

The average batter life of the iphone 4s is reported to be

The average batter life of the iPhone 4S is reported to be 6.0 hours by Apple. Assume that the population standard deviation for the better life for this cell phone is 30 minutes. A random sample of 50 iPhones had an ave ...

1 what are the four basic goals of behavioral research2

1. What are the four basic goals of behavioral research? 2. Distinguish between basic and applied research. In what ways are basic and applied research interdependent?

The total cholesterol levels of a sample of men aged 35-44

The Total Cholesterol levels of a sample of men aged 35-44 are normally distributed with the mean of 203 milligrams per deciliter and a standard deviation of 37.4 milligrams per deciliter. (a) What percent of men have a ...

  • 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