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

1nbspthe owner of a professional basketball team claims

1) The owner of a professional basketball team claims that the mean attendance at games is over 25,000 and therefore the team needs a new arena. Determine whether the hypothesis test for this claim is left-tailed, right- ...

1 explain why the byzantium empire went in a different

1. Explain why the Byzantium Empire went in a different direction from Europe (even though both were Christian) after the breakup of Rome. This will require some examination of historical and geographical influences, jus ...

What was the highest point of the popes power and what was

What was the highest point of the pope's power and what was the lowest point?

Afire with faith 1820-18501 how did revivalism help people

Afire with Faith, 1820-1850} 1. How did revivalism help people adjust to the market? 2. Describe the range of antislavery positions, and mention at least three people who exemplified those different positions? 3. How did ...

Dan is at the bottom of donnas preference list and donna is

Dan is at the bottom of Donna's preference list, and Donna is at the bottom of Dan's preference list. Is it possible that there is a stable matching that matches Dan to Donna? Justify your answer.

Locate the data set banksav and open it with spss follow

Locate the data set "Bank.sav" and open it with SPSS. Follow the steps in section 10.15 Learning Activity as written. Answer all of the questions in the activity based on your observations of the SPSS output. Type your a ...

Identify a business related management problem translate

Identify a business related management problem translate the management problem into a hypothesis assumption accurately state the null hypothesis and alternative hypothesis.

Questions1 the following results were observed in a

QUESTIONS: 1. The following results were observed in a prospective study of the drug Viagra (based on data from Pfizer Inc.)  Use the data to answer the following questions:   Viagra Treatment Placebo Headache 117 29 No ...

The price of a railroad car purchased by rio corporation

The price of a railroad car purchased by Rio Corporation was $78,600. Using the MACRS method, calculate the annual depreciation for year 3. (Round all dollar amounts to the nearest cent) $34,371.78 $19,249.14 $13,747.14 ...

1 what does the error of estimation tell us about the

1. What does the error of estimation tell us about the results of a study conducted using probability sampling? 2. What happens to the error of estimation as one's sample size increases?

  • 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