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

What would the null and alternate hypothesis be for the

What would the null and alternate hypothesis be for, " The airlines claim that complaints average less than 15 per month per airport. To investigate the problem an independent watchdog agency contacted a random sample of ...

A prospective purchaser wishes to estimate the mean dollar

A prospective purchaser wishes to estimate the mean dollar amount of sales per customer at a toy store located in an airport terminal. Based on data from other similar airports, the standard deviation of such sales is ab ...

For each of the following three cases explain i the

For each of the following three cases, explain (i) the hypotheses with a plausible definition of p1 and p2, (ii) whether or not the data indicate practical significance (use common sense and/or general knowledge), and (i ...

A system has two components that operate in parallel at

A system has two components that operate in parallel. At least one of the components must function properly if the system is to function properly. The probabilities of failures for the components 1 and 2 during one perio ...

Assume that womens heights are normally distributed with a

Assume that women's heights are normally distributed with a mean given by mu equals 63.3 in, and a standard deviation given by sigma equals 3.1 in. Complete parts a and b. a. If 1 woman is randomly selected, find the pro ...

Focusing on leadership and changeintroductionin this

Focusing on leadership and change Introduction In this assignment, we will focus on you, your relationship to leadership and change in your work context and the management ideas that have influenced those topics. Rather ...

Suppose that utility payoffs depend on decisions and states

Suppose that utility payoffs depend on decisions and states as shown in Table 1.3. Letp(θ1,),p(θ2)) denote the decision-makers subjective probability distribution over Ω = {θ1 ,θ2}. a. Suppose first that B = 35. For what ...

Assignment quantitative methodsquestion 1 a large shipping

ASSIGNMENT: QUANTITATIVE METHODS QUESTION 1: A large shipping company recorded the tonnage shipped weekly across the pacific for 50 weeks. The data is presented in the table below. 530 492 462 379 487 523 600 618 548 431 ...

Business quantative analysis and statistics 1project

BUSINESS QUANTATIVE ANALYSIS AND STATISTICS 1 Project Management Scenario: You are a consultant with expertise in project management strategies. Select a possible project management situation from your current or future ...

Assume that population means are to be estimated from the

Assume that population means are to be estimated from the samples described. Use the sample results to approximate the margin of error and 95% confidence interval. Sample size equals=6464, sample mean equals=8282, sample ...

  • 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