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

1 what are the most important threats to validity that

1. What are the most important threats to validity that occur in quasi experimental research designs when the research is conducted over a period of time? What techniques can be used to minimize these potential interpret ...

You are playing blackjack in a casino the casino is using a

You are playing blackjack in a casino. The casino is using a single, 52 card deck. Shuffling the deck takes time. So rather than shuffling the deck after each hand, the casino deals three hands before shuffling. The used ...

1 true or false justify for

1. True or False. Justify for fullcredit. (a) A is an event, and Ac is the complement of A, then P(A AND Ac ) =0. (b) If the variance of a data set is 0, then all the observations in this data set must bezero. (c) If a 9 ...

1 describe how structural equations modeling works2

1. Describe how structural equations modeling works. 2. Distinguish between latent variable modeling and path analysis as types of structural equations modeling.

Case study mikhail gorbachevs 1988 un speechif the pace of

Case Study: Mikhail Gorbachev's 1988 UN SpeechIf the pace of improving US-Soviet relations seemed rapid, Mikhail Gorbachev's speech to the United Nations General Assembly would shift the process into overdrive.  In this ...

Christine has always been weak in mathematics based on her

Christine has always been weak in mathematics. Based on her performance prior to the final exam in Calculus, there is a 45% chance that she will fail the course if she does not have a tutor. With a tutor, her probability ...

A philosophy professor assigns letter grades on a test

A philosophy professor assigns letter grades on a test according to the following scheme. A: Top 12% of scores B: Scores below the top 12% and above the bottom 63% C: Scores below the top 37% and above the bottom 22% D: ...

Suppose that a certain college class contains 65 students

Suppose that a certain college class contains 65 students. Of these, 35 are seniors, 33 are biology majors, and 5 are neither. A student is selected at random from the class. (a) What is the  probability  that the studen ...

How do you interpret the p-values in a regression output

How do you interpret the p-values in a regression output? What does a p-value of .0495 mean? What significance level is this?

Using the table below compute the spearman rank correlation

Using the table below, compute the spearman rank correlation coefficient for the aggressiveness scores. Does this suggest that both twins tend to be similar in degrees of aggressiveness? Twin set 1 st  born aggressivenes ...

  • 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