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

Suppose that the matching problem is to match nm men to nw

Suppose that the matching problem is to match nm men to nw women, where nw (a) Describe in detail the generalization of the Gale-Shapley algorithm for this case. Prove that the algorithm terminates with a stable matching ...

For this assignment you will continue to use data derived

For this assignment you will continue to use data derived from Capital Bikeshare trip records from 2011 and 2012, this time analysing patterns in daily numbers of rentals by casual users. References and Data Sources: Bac ...

Assignment1what is statistics2describe the differences

Assignment 1. What is statistics? 2. Describe the differences between inferential statistics and descriptive statistics. 3. The call center received 30 phone calls on a Monday, below is the number of minutes each call la ...

What tensions emerged in the southwest that threatened to

What tensions emerged in the Southwest that threatened to lead the United States into a war with Mexico? On what grounds did President James K. Polk ask Congress to declare war on Mexico?

A weight-loss company wants to statistically prove that its

A weight-loss company wants to statistically prove that its methods work. They randomly selected 10 clients who had been on the weight loss program for between 55 and 65 days. They looked at their beginning weights and t ...

At a school pep rally a group of sophomore students

At a school pep rally, a group of sophomore students organized a free raffle for prizes. They claim that they put the names of all the students in the school in the basket and that they randomly drew 36 names out of this ...

125 wordsexplain the history behind the black soldier of

125 words Explain the history behind the Black Soldier of the Civil War In this forum look beyond the book for information on specific units, soldiers and even the reasons for why Lincoln allowed the African American to ...

Consider a decision-maker whose subjective probability

Consider a decision-maker whose subjective probability distribution over the set of possible states Ω is p = (p(s)) We ask him to tell us his subjective probability distribution, but he can lie and report any distributio ...

Peter has two envelopes he puts 10k euros in one and 10k1

Peter has two envelopes. He puts 10k euros in one and 10 k+1 euros in the other, where k is the outcome of the toss of a fair die. Peter gives one of the envelopes to Mark and one to Luke (neither Mark nor Luke knows the ...

1 distinguish between a quota sample and a purposive

1. Distinguish between a quota sample and a purposive sample. 2. What three criteria characterize good descriptions of data?

  • 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