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

In a recent survey of high school seniors a random sample

In a recent survey of high school seniors, a random sample of 1000 females showed that 650 were planning on pursuing a college degree, while a random sample of 1000 females showed that 600 were planning on pursuing a col ...

The mean gross annual incomes of certified plumbers are

The mean gross annual incomes of certified plumbers are normally distributed with the mean of $36,000 and a standard deviation of $3,572. The ship building association wishes to find out whether this number is still accu ...

Islam and the other monotheistic religions write an essay

Islam and the other monotheistic religions: Write an essay discussing the relationship between Islam, Judaism and Christianity. What does the Qur'an say about the "Peoples of the Book," and how they are to be treated? Wh ...

A recent report suggested that older people think more

A recent report suggested that older people think more slowly than younger people because they have more information stored in their brains. Because WeStudyEverything wasn't sure regarding the source of the study, they d ...

The amount of soda a dispensing machine pours into a 12

The amount of soda a dispensing machine pours into a 12 ounce can of soda follows a normal distribution with a standard deviation of 0.08 ounce. Every can that has more than 12.20 ounces of soda poured into it causes a s ...

A clinical trial is being planned to investigate the effect

A clinical trial is being planned to investigate the effect of a new experimental drug designed to reduce total serum cholesterol. Investigators will enroll participants with total cholesterol levels between 200-240, the ...

All the customers who entered a store on a particular day

All the customers who entered a store on a particular day were given a surgery to fill out concerning their opinions of the service at the store? What type of sample is this? I can't decide between voluntary response or ...

Purpose of the studythis current research study is a

Purpose of the Study This current research study is a quantitative study. The aim of this research study is to investigate the levels of self-efficacy and to determine whether there is a relationship in quality of life a ...

On a 2-d regular not wrapped-around mesh a message from a

On a 2-D regular (not wrapped-around) mesh, a message from a source (X s , Y s ) is to be sent to a destination (X d , Y d ). If any shortest path can be used, what is the probability that the message follows the shortes ...

Suppose that the probability that a new medication will

Suppose that the probability that a new medication will cause a bad side effect is 0.03. If this medication is given to 150 people, what is the probability that exactly three of them will experience a bad side effect? Pl ...

  • 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

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

Describe what you learned about the impact of economic

Describe what you learned about the impact of economic, social, and demographic trends affecting the US labor environmen