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

Generally researchers are more concerned about making a

Generally, researchers are more concerned about making a Type I error than a Type II error. Can you think of any instances in which you might be more concerned about making a Type II error?

1 what is the difference between a stratum and a cluster2

1. What is the difference between a stratum and a cluster? 2. What is the drawback of obtaining random samples by telephone? 3. In what way would the use of sampling improve the accuracy of the United States census?

Please no plagiarism1 compare and contrast the northern and

Please no plagiarism. 1. Compare and contrast the Northern and Southern economies and societies in the antebellum period. How did industrialization develop in the North, and plantation slavery in the South? How did the e ...

Prior to distributing a large shipment of bottled water a

Prior to distributing a large shipment of bottled water, a beverage company would like to determine whether there is evidence that the true mean fill volume of all bottles di↵ers from 600 ml, which is the amount stated o ...

1 the waiting time t between successive occurrences of an

1. The waiting time T between successive occurrences of an event E in a discrete time renewal process has the probability distribution P(T =1) = 0.7, P(T = 2) = 0.3. (iii) If an observer arrives after the renewal process ...

The number of credits being taken by a sample of 13

The number of credits being taken by a sample of 13 full-time college students are listed below. Find the mean, median, and mode of the data, if possible. If any measure cannot be found or does not represent the center o ...

What was manifest destiny what forces created this concept

What was Manifest Destiny? What forces created this concept? How was it to be achieved, and what doubts were raised as to its desirability?

A gallup poll claims that at least 60 of adults in the

A Gallup poll claims that at least 60% of adults in the United States have used the Internet for shopping. In a survey of 1,025 randomly selected adults in the U.S., 678 said that they have used the Internet for shopping ...

Carter motor company claims that its new sedan the libra

Carter Motor Company claims that its new sedan, the Libra, will average better than 24 miles per gallon in the city. Use μ, the true average mileage of the Libra. Express the null hypothesis and the alternative hypothesi ...

Imagine that you want to know whether the sat is biased

Imagine that you want to know whether the SAT is biased against Group X and in favor of Group Y. You administer the SAT to members of the two groups; then, 4 years later, you examine the correlations between SAT scores 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

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