+1-415-315-9853

info@mywordsolution.com

## Statistics

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 ...

• 13,132 Experts

## 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.

### 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