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

Two students play the following game two dice are tossed if

Two students play the following game. Two dice are tossed. If the sum of the numbers showing is less than 7, student A collects a dollar from student B. If the total is greater than 7, then student B collects a dollar fr ...

Can the sample standard deviations s1 and s2 be used in

Can the sample standard deviations s1 and s2 be used in place of the population standard deviations σ1 and σ2? 1. "Testing the Difference between Two Means." (Note: Please respond to only one of the following two bullete ...

Two zero-mean discrete random processesnbspnbspare

Two zero-mean discrete random processes   are statistically independent and have autocorrelation functions given by   and   Let a new random process   (a) Find  Plot all three autocorrelation functions. (b) Determine all ...

For each of these questions you must provide a diagram

For each of these questions you must provide a diagram indicating the area or the percentile of the relevant distribution for the question. These diagrams can be drawn and photographed with the picture file pasted in the ...

Until about 1830 most western settlers were southerners who

Until about 1830, most western settlers were southerners who settled near the tributaries of the Ohio-Mississippi River system. True or False?

In a certain lottery six numbers are randomly chosen from

In a certain lottery, six numbers are randomly chosen from the set   (without replacement). To win the lottery, a player must guess correctly all six numbers but it is not necessary to specify in which order the numbers ...

Msa stat workshop assessment requirements1 what is the

MSA STAT Workshop Assessment REQUIREMENTS 1. What is the population Regression function? ("GNP"  is dependent, and "Invest," "CPI" and "Interest" are independent) 2. Is this regression function significant overall (state ...

Letnbspnbspnbspbe a random process where

Let     be a random process, where A n  and    is the Kronecker delta function. This process is sometimes used as a model for random noise. (a) Find the time-varying autocorrelation function  (c) Find the PSD of this pro ...

A exponential random variable has a pdf given by fxx

An exponential random variable has a PDF given by f x (x) = exp(-x)u(x). (a) Find the mean and variance of X . (b) Find the conditional mean and the conditional variance given that X > 1 .

1 a florist is going to make a five flower arrangement from

1. A florist is going to make a five flower arrangement from the following flowers: a lily, a rose, a carnation, a daisy, a dahlia, and an iris. What is the probability of her not choosing a daisy? *Enter the fraction us ...

  • 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

A cola-dispensing machine is set to dispense 9 ounces of

A cola-dispensing machine is set to dispense 9 ounces of cola per cup, with a standard deviation of 1.0 ounce. The manuf

What is marketingbullwhat is marketing think back to your

What is Marketing? • "What is marketing"? Think back to your impressions before you started this class versus how you

Question -your client david smith runs a small it

QUESTION - Your client, David Smith runs a small IT consulting business specialising in computer software and techno

Inspection of a random sample of 22 aircraft showed that 15

Inspection of a random sample of 22 aircraft showed that 15 needed repairs to fix a wiring problem that might compromise

Effective hrmquestionhow can an effective hrm system help

Effective HRM Question How can an effective HRM system help facilitate the achievement of an organization's strate