Ask Question, Ask an Expert

+61-413 786 465

info@mywordsolution.com

Ask Statistics and Probability Expert

Scatterplot a) Make an XY scatter plot linked to the following data on this sheet. X Y 6.981 12.266 3.982 8.455 2.084 5.951 9.113 14.395 2.280 7.435 6.567 11.332 1.897 7.011 7.186 12.716 4.094 9.214 1.257 7.499 7.199 10.473 2.136 6.124 3.032 8.832 3.735 9.295 8.612 34.622 0.338 7.155 5.348 10.475 9.208 13.650 7.570 13.910 8.646 11.895 1.953 7.387 3.475 7.871 3.962 10.482 8.084 11.727 4.866 8.688 b) The scatterplot reveals an outlier. Copy the data to a new sheet or a new area on this sheet, and remove the outlier. You should now have 24 rows of data above. Make a new scatterplot from the revised data. c) Right click on the points, Add Trendline, Display Equation on chart, Display R-Squared value on chart d) Read the intercept directly from the chart equation label. The elevation of the line above the origin with 3 decimal places = e) Read the slope directly from the chart equation label. The slope of the line with 3 decimal places = f) So, when X increases by 1, the change in Y = g) Read R2directly from the chart equation label. The amount of the variation in Y explained by X in percent is =

Statistics and Probability, Statistics

  • Category:- Statistics and Probability
  • Reference No.:- M92551916
  • Price:- $10

Priced at Now at $10, Verified Solution

Have any Question?


Related Questions in Statistics and Probability

The number of defective items produced by a machine in a

The number of defective items produced by a machine in a large factory follows a Poisson distribution with a rate of λ=1.5 per day. What is the probabilityThe machine produces exactly zero defective items on exactly two ...

The weights of ice cream cartons are normally distributed

The weights of ice cream cartons are normally distributed with a mean weight of 20 ounces and a standard deviation of 0.5 ounces. You randomly select 25 cartons. What is the probability that their mean weight is greater ...

An important part of the customer service responsibilities

An important part of the customer service responsibilities of a cable company relates to the speed with which trouble in service can be repaired. Historically, the data show that the likelihood is 0.75 that troubles in a ...

Rippards has a debt ratio of 15 a total asset turnover

Rippard's has a debt ratio of 15%, a total asset turnover ratio of 3.0 and a return on equity (ROE) of 48%. Compute Rippard's net profit margin.

Monthly water bills for a city have a mean of 10843 and a

Monthly water bills for a city have a mean of $108.43 and a standard deviation of $36.98. Find the probability that a randomly selected bill will have an amount greater than $165, which the city believes might indicate t ...

When you purchased your house you took out a 30-year

When you purchased your? house, you took out a? 30-year annual-payment mortgage with an interest rate of 7% per year. The annual payment on the mortgage is 16,803. You have just made a payment and have now decided to pay ...

On average the parts from a supplier have a mean of 975

On average, the parts from a supplier have a mean of 97.5 inches and a standard deviation of 12.2 inches. Find the probability that a randomly selected part from this supplier will have a value between 85.3 and 109.7 inc ...

A bullying prevention program is underway in the phoenix

A bullying prevention program is underway in the phoenix school districts. The researchers ran multiple analyses with the baseline data. The researchers want to determine if there is a relationship between age (13, 14, 1 ...

Question a gamble is said to be fair if each player has the

Question: A gamble is said to be fair if each player has the same expected outcome. Suppose we play a game in which the first of two players receives $50 each time the roll of a balanced die comes up with a 1 or 6. Playe ...

Below are commute times and amounts of rainfall for a few

Below are commute times and amounts of rainfall for a few randomly selected dates last year. Rain (mm) Commute time (min) 3 20 0 10 1 25 9 30 15 60 12 25 Treat "Rain" as the X variable Compute the value of r for the corr ...

  • 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

Why might a bank avoid the use of interest rate swaps even

Why might a bank avoid the use of interest rate swaps, even when the institution is exposed to significant interest rate

Describe the difference between zero coupon bonds and

Describe the difference between zero coupon bonds and coupon bonds. Under what conditions will a coupon bond sell at a p

Compute the present value of an annuity of 880 per year

Compute the present value of an annuity of $ 880 per year for 16 years, given a discount rate of 6 percent per annum. As

Compute the present value of an 1150 payment made in ten

Compute the present value of an $1,150 payment made in ten years when the discount rate is 12 percent. (Do not round int

Compute the present value of an annuity of 699 per year

Compute the present value of an annuity of $ 699 per year for 19 years, given a discount rate of 6 percent per annum. As