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 research concludes that the number of hours of exercise

A research concludes that the number of hours of exercise per week for adults is normally distributed with a mean of 3.5 hours and a standard deviation of 3 hours. Show all work. Just the answer, without supporting work, ...

Describe the collapse of the soviet union begin with the

Describe the collapse of the Soviet Union. Begin with the events during the 1980s including the entire Gorbachev era. Should include at least the following topics: 1. Poland's democratic revolution of the 1980s 2. Gorbac ...

A bakery was taken to court for selling loaves of bread

A bakery was taken to court for selling loaves of bread that were underweight. These loaveswere advertised as weighing 24 ounces. In its defense, the bakery claimed that the advertisedweight was meant to imply not that e ...

1 find the p valuep for the indicated hypothesis test with

1) Find the P value(P= ?) for the indicated hypothesis test with the given standardized test statistic z. Decide whether to reject Ho for the given level of significance.  Two tail test, z = 2.30, alpha = 0.01 2) Find th ...

A recent study that examined bone strength collected data

A recent study that examined bone strength collected data from cadaveric femurs from subjects in three age groups. The data are below. Does mean bone strength differ for the three age groups? Use a 5% level of significan ...

1 what value of cronbachamp39s alpha coefficient indicates

1. What value of Cronbach's alpha coefficient indicates acceptable interitem reliability? 2. Why are researchers sometimes not able to test the reliability of their measures? 3. What steps can be taken to increase th ...

The annual commissions earned by sales representatives of

The annual commissions earned by sales representatives of Machine Products, Inc. a manufacturer of light machinery, follow the normal probability distribution.  The mean yearly amount earned is $40,000 and the standard d ...

Consumer reports provided extensive testing and ratings for

Consumer Reports provided extensive testing and ratings for more than 100 HDTVs. An overall score, based primarily on picture quality, was developed for each model. In general, a higher overall score indicates better per ...

Research objectives to explore correlations between reward

Research Objectives To explore correlations between reward systems and team work attributes in the Saudi Arabian bank sector To explore relationships between reward systems and team work effectiveness in the Saudi Arabia ...

Locate one article presenting research using polynomial

Locate one article presenting research using polynomial regression. Your task now is to critique the appropriateness, utility, alternatives, strengths, and weaknesses of the use of statistics to support the hypotheses of ...

  • 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