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

A researcher would like to study bmi levels in adults 20-40

A researcher would like to study BMI levels in adults 20-40 years of age. She selected 9 patients and found their BMI values to be: 38, 19, 25, 26, 29, 18, 34, 32, 30 The mean BMI level of this group of patients is 25.8 ...

A drug company wants to analyze if its new marketing

A drug company wants to analyze if its new marketing strategy adopted last year is successful is increasing sales. It randomly chooses 49 drugs from its list of products. For each drug, it computes the sales (in million ...

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 ...

1 travelers are asked how many hours they are willing to

1. Travelers are asked how many hours they are willing to drive while on vacation in one day. A total of 86 travelers reported a mean of 11.55 hours with a standard deviation of 1.2 hours. Find the 99% confidence interva ...

1 how do quasi-experimental designs differ from true

1. How do quasi-experimental designs differ from true experiments? 2. Under what circumstances would a researcher use a quasi-experimental rather than an experimental design?

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?

44nbspof a certain countrys voters think that it is too

44% of a certain country's voters think that it is too easy to vote in their country. You randomly select 12 likely voters. Find the probability that the number of likely voters who think that it is too easy to vote is ( ...

1 why are psychologists sometimes interested in

1. Why are psychologists sometimes interested in epidemiology? 2. Why do researchers use probability rather than nonprobability samples when doing descriptive research?

This exercise generalizes exercise 925 let n y fi fii s p

This exercise generalizes Exercise 9.25. Let (N, Y, F I , F II , s, P) be an Aumann model of incomplete information with beliefs in which N = {I, II} and let A ⊆ Y be an event. Consider the following process: Player I in ...

Problem 1 if we were to visit europa one of jupiters

Problem 1: If we were to visit Europa (one of Jupiter's Galilean moons) and we were to look at the sky, what would be Jupiter's angular size if Jupiter is in average 670,900 km away from Europa and has a diameter of 139, ...

  • 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