+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

### Generally researchers are more concerned about making a

Generally, researchers are more concerned about making a Type I error than a Type II error. Can you think of any instances in which you might be more concerned about making a Type II error?

### 1 what is the difference between a stratum and a cluster2

1. What is the difference between a stratum and a cluster? 2. What is the drawback of obtaining random samples by telephone? 3. In what way would the use of sampling improve the accuracy of the United States census?

### Please no plagiarism1 compare and contrast the northern and

Please no plagiarism. 1. Compare and contrast the Northern and Southern economies and societies in the antebellum period. How did industrialization develop in the North, and plantation slavery in the South? How did the e ...

### Prior to distributing a large shipment of bottled water a

Prior to distributing a large shipment of bottled water, a beverage company would like to determine whether there is evidence that the true mean fill volume of all bottles di↵ers from 600 ml, which is the amount stated o ...

### 1 the waiting time t between successive occurrences of an

1. The waiting time T between successive occurrences of an event E in a discrete time renewal process has the probability distribution P(T =1) = 0.7, P(T = 2) = 0.3. (iii) If an observer arrives after the renewal process ...

### The number of credits being taken by a sample of 13

The number of credits being taken by a sample of 13 full-time college students are listed below. Find the mean, median, and mode of the data, if possible. If any measure cannot be found or does not represent the center o ...

### What was manifest destiny what forces created this concept

What was Manifest Destiny? What forces created this concept? How was it to be achieved, and what doubts were raised as to its desirability?

### A gallup poll claims that at least 60 of adults in the

A Gallup poll claims that at least 60% of adults in the United States have used the Internet for shopping. In a survey of 1,025 randomly selected adults in the U.S., 678 said that they have used the Internet for shopping ...

### Carter motor company claims that its new sedan the libra

Carter Motor Company claims that its new sedan, the Libra, will average better than 24 miles per gallon in the city. Use μ, the true average mileage of the Libra. Express the null hypothesis and the alternative hypothesi ...

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

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

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