Question

Asked Dec 1, 2019

1 views

Step 1

**27)**

** **

**Excel Procedure for Regression:**

- Enter the data for
*x*and*y*in Excel sheet. - Go to
**Data** - Click on
**Data Analysis**. - Select
**‘Regression’**and click on ‘OK’ - Select the column of
under ‘Input Y Range’.*y* - Select the column of
under ‘Input X Range’.*x* - Click on ‘OK’.

**Excel Output:**

Step 2

From the output, the regression equation is *Y*=122.506444+1.820697*x*.

The standard error of the estimate is ** 16.51184** and it is calculated below:

From the Excel output, the residual mean sum of squares is 272.6408264.

Step 3

The 95% prediction interval for *x*=58 is **(179,279)** and it is calculated below:

The pre...

Tagged in

Find answers to questions asked by student like you

Show more Q&A

Q: In a survey, 20 people were asked how much they spent on their child's last birthday gift. The resul...

A: Given information:It is given that mean is 37.7 (x-bar); the standard deviation (s) is 16.7; the sam...

Q: Find the z value that corresponds to the given area in the figure below. Use a graphing calculator a...

A: It is given that Z is the standard normal variable. The required z-value can be obtain using MINITAB...

Q: I need help with normal curve

A: (a)The probability that a randomly selected light bulb will last between 1000 and 1250 hours is 0.45...

Q: A teacher wants to assign an 'A' grade to everyone that scores in the 80th percentile. The grades a...

A: The 80th percentile value is 75 and it is calculated below: From the given information, the grades a...

Q: Thirty percent of consumers prefer to purchase electronics online. You randomly select 8consumers. F...

A: Given:Probability of success (p) = 0.30Number of trials (n) = 8Consider, X be the random variable th...

Q: A study compared different psychological therapies for teenage girls suffering from anorexia. The st...

A: Click to see the answer

Q: Although older Americans are most afraid of crime, it is young people who are more likely to be the ...

A: Hello there! there are more than three subparts in the question. According to our policies we cannot...

Q: Use the standard normal table to find the z-score that corresponds to the given percentile. If the a...

A: The z-score that corresponds to P90 is 1.28, which is obtained by using the Excel function “=Norm.IN...

Q: You wish to test the following claim (HaHa) at a significance level of α=0.05α=0.05. Ho:p1=p2 ...

A: According to the provided information,