Question

You generate a scatter plot using Excel. You then have Excel plot the trend line and report the equation and the r2 value. Th

0 0
Add a comment Improve this question Transcribed image text
Answer #1

Ans:

Given that

coefficient of determination,r^2=0.4356

Correlation coefficient,r=sqrt(0.4356)=0.66

Add a comment
Know the answer?
Add Answer to:
You generate a scatter plot using Excel. You then have Excel plot the trend line and...
Your Answer:

Post as a guest

Your Name:

What's your source?

Earn Coins

Coins can be redeemed for fabulous gifts.

Not the answer you're looking for? Ask your own homework help question. Our experts will answer your question WITHIN MINUTES for Free.
Similar Homework Help Questions
  • omework Due Thu 05/31/2018 11:59 pm generate a scatter plot using Excel. You then have Excel...

    omework Due Thu 05/31/2018 11:59 pm generate a scatter plot using Excel. You then have Excel plot the trend line and report the equation and the r2 value. The regression equation is reported as You y 96.76x + 63.01 and the r20.4624 What is the correlation coefficient for this data set? License Points possible: 1 This is attempt 1 of 4 Submit

  • Using your favorite statistics software package, you generate a scatter plot with a regression equation and...

    Using your favorite statistics software package, you generate a scatter plot with a regression equation and correlation coefficient. The regression equation is reported as - 13.83.2 + 86.29 and the r= -0.771. What proportion of the variation in y can be explained by the variation in the values of x?! % Report answer as a percentage accurate to one decimal place.

  • Show Intro/Instructions Using your favorite statistics software package, you generate a scatter plot with a regression...

    Show Intro/Instructions Using your favorite statistics software package, you generate a scatter plot with a regression equation and correlation coefficient. The regression equation is reported as y = 81.28.1 + 71.93 and the r = -0.85. What percentage of the variation in y can be explained by the variation in the values of x? 72 % (Report exact answer, and do not enter the % sign) Points possible: 1 This is attempt 1 of 3. Submit a $ o

  • For each of the data sets, create a scatter plot with the regression line and answer...

    For each of the data sets, create a scatter plot with the regression line and answer these questions. What is r, r2, Critical Value (CV)? In general, what does r2 mean? What does r2 mean specifically for the data set? What is the regression equation? Is there any positive or negative correlation? Interpret b1. Interpret b0. Forecast the next year. Year Revenue ($) 1 1002 2 1108 3 967 4 1054 5 1206 6 1400

  • Using your favcrite statistics software paxkage. you generate a scatter plat with a regression equation and...

    Using your favcrite statistics software paxkage. you generate a scatter plat with a regression equation and correlation coefficierk. The regression equation is reported as and the r0.688 What proportion of the variation in y can be explained by the variation in the values of xa 65.Mir 42.31 Report answer as a percentage accurate to one decimal place. Points possible d d athampsS submit

  • For each of the data sets, create a scatter plot with the regression line and answer...

    For each of the data sets, create a scatter plot with the regression line and answer these questions. What is r, r2, Critical Value (CV)? In general, what does r2 mean? What does r2 mean specifically for the data set? What is the regression equation? Is there any positive or negative correlation? Interpret b1. Interpret b0. Forecast the next year. Year Cost (Thousands of dollars) 1 100 2 99 3 102 4 80 5 90 6 82 7 80 8...

  • 13. You are given the following regression equation for a scatter plot which The displays data...

    13. You are given the following regression equation for a scatter plot which The displays data for x = Weight of Car (in pounds) and y = Miles per Gallon in City: y = −0.006x + 42.825 r2 = 0.7496 (Note: The scatter plot graph is attached to the Canvas assignment as a separate document.) (a) Find the value of r based on the information given. (b) Based on your value of r, what conclusion can you make about the...

  • For each of the data sets, create a scatter plot with the regression line and answer...

    For each of the data sets, create a scatter plot with the regression line and answer these questions What is r, r^2, Critical Value (CV)? In general, what does r^2 mean? What does r^2 mean specifically for the data set? What is the regression equation? Is there any positive or negative correlation? Interpret b1. Interpret b0. Forecast the next year. Model your answers off the Excel file of the solutions found under Content, 3B

  • You are given the following regression equation for a scatter plot which The displays data for...

    You are given the following regression equation for a scatter plot which The displays data for X= weight of car (in pounds) and y= Miles per gallon in City: Equation: y=-0.006x + 42.825 and r2= 0.7496. a. find the value of r2 based on the information given. b. Based on your value of r, what conclusion can you make about the correlation of this data? c. What does the value of r2 tell you about the regression? d. Use the...

  • Find the equation of the regression line for the given data. Then construct a scatter plot...

    Find the equation of the regression line for the given data. Then construct a scatter plot of the data and draw the regression line.​ (The pair of variables have a significant​ correlation.) Then use the regression equation to predict the value of y for each of the given​ x-values, if meaningful. The number of hours 6 students spent for a test and their scores on that test are shown below. Hours spent studying comma xHours spent studying, x 0 2...

ADVERTISEMENT
Free Homework Help App
Download From Google Play
Scan Your Homework
to Get Instant Free Answers
Need Online Homework Help?
Ask a Question
Get Answers For Free
Most questions answered within 3 hours.
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT