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

An iq test is designed so that the mean is 100 and the

An IQ test is designed so that the mean is 100 and the standard deviation is 16 for the population of normal adults. Find the sample size necessary to estimate the mean IQ score of statistics students such that it can be ...

Assignment- inferences and linear regression1a left-tail

Assignment- Inferences and Linear Regression 1. A left-tail area in the chi-square distribution equals 0.95. For df = 10, the table value equals A. 18.307. B. 20.483. C. 3.940. D. 15.987. 2. Which of the following statem ...

A person goes to his office everyday he has a single

A person goes to his office everyday. He has a single umbrella. When he is home and the umbrella is home, he can choose to bring it. He will certainly do so if it is raining, but must decide what to do if is not raining, ...

The university is attempting to set its staffing plan for

The University is attempting to set its staffing plan for the next several year, and it wants to determine if the distribution of students among various graduate majors has changed from the historical averages which were ...

Imagine that you want to know whether the sat is biased

Imagine that you want to know whether the SAT is biased against Group X and in favor of Group Y. You administer the SAT to members of the two groups; then, 4 years later, you examine the correlations between SAT scores a ...

There are 1000 students in a high school among the 1000

There are 1000 students in a high school. Among the 1000 students, 150 students take AP Statistics, and 300 students take AP French. 100 students take both AP courses. Let S be the event that a randomly selected student ...

1 prove that every complete irreflexive and transitive

1. Prove that every complete, irreflexive, and transitive relation is asymmetric: if x ≠ y, then x > y if and only if y x. 2. Prove that the Gale-Shapley algorithm for finding a stable matching satisfies the following pr ...

What have you learned about the city-states in greece that

What have you learned about the city-states in Greece that you can apply to creating contact between your band of survivors and other survivor groups? Does a city-state work for your group or do you want to form another ...

A committee comprised of 15 members is called upon to

A committee comprised of 15 members is called upon to choose the prettiest color: red, blue, or yellow. The committee members simultaneously announce their strict preference relations among these three colors. If red is ...

The amount of time people spend in a clothing store is

The amount of time people spend in a clothing store is normally distributed with a mean of 18 mins and SD of 4 mins. If a sample of 20 customers is randomly selected. what is this probability they will spend more than 20 ...

  • 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

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

Describe what you learned about the impact of economic

Describe what you learned about the impact of economic, social, and demographic trends affecting the US labor environmen