The paired data below consists of test scores and hours of preparation for 5 randomly selected students. Use this data set to answer the questions below:x Hours of preparation 5 2 9 6 10y Test score 64 48 72 73 801. Use the given data to find the correlation coefficient r, regression equation and scatter plot in MS Excel. Solution:Instructor Comments:2. Based on the linear correlation coefficient r, is this a good model? Explain.Solution:Instructor Comments:3. What is the best predicted test score for a student who spent 7 hours preparing for the test?Solution:Instructor Comments:4. Find the standard error . Use formula or MS Excel.Solution:Instructor Comments:5. Find the 99% prediction interval for the test score of a person who spent 7 hours preparing for the test.Solution:Instructor Comments:6. Find the explained variation.Solution:Instructor Comments:7. Find the unexplained variation.Solution:Instructor Comments:8. Find the total variation.Solution:Instructor Comments:9. Find the value of r2 and explain its meaning.Solution:Instructor Comments:10. If the data point ( 3, 100) is added to the data set, how would this effect the results of the regression analysis? Is this data point an outlier, influential point or both? Explain.Solution:Instructor Comments:

Write a minimum 4 page report explaining the results from your analysis of the ROI of Business Majors and Engineering Majors. Use your results from each week’s assignment to make this report.This report should include:A detailed description of the data used in this analysis – specifically explain what the data in each column represents.A detailed explanation of any information learned about:School Type for each major; The Cost for each major;The 30 Year ROI for each major;The Annual % ROI for each major.Explanations should be supported with the results obtained from your work in previous weeks.Finally, answer the following questions and support your answer with your results.Does there appear to be a particular major that gives a better ROI? Why or Why not? Given that we are using statistical inference to make our conclusions, is it guaranteed that the major you choose that gave a better ROI for this sample will always have a better ROI than the other major? Explain your reasoningDOCUMENTS BELOW TO ANALYZE

Research an article on a current event that centers on a controversial issue where the two sides are claiming opposing views. Then, describe how you would analyze the situation to settle the issue if you were involved in this event. For example, if the article was about whether a proposed new law about gun control will reduce deaths, you may describe how you would use hypothesis testing to compare data from states where such laws exist. Or, if the article was about actions to take to reduce gas prices, you could talk about how you would use regression to figure out which factors affected prices at the pump the most. General discussions like “should marijuana be legal” or “do vaccines cause autism” are not appropriate. Pick a current and specific debate.Please note that this discussion should be limited to how statistical analysis can be applied to current issues. This is not the place to champion a particular position on the issue you are discussing or get into an argument about the various sides of an issue. Remember, you are here to analyze, not proselytize.Also note that the article you are citing must be discussing the opposing views on the issue. Do not introduce your own perspective on what is being disputed. For example if the article is about the new budget being passed but does not discuss any conflicts of opinion, it doesn’t qualify.Please use the template below in your answers so everyone can easily follow your answers to all the questions (copy and paste to your post).Use this template for your Unit 6 Discussion.Summary of the articleBriefly describe the current event described in the article.Central questionWhat does the article say about the issue being disputed? What are the conflicting points of view according to the article? Use direct quotes from the article to summarize the dispute and the opposing sides.There has to be some specific issue in dispute at the center (do tax breaks increase spending, what impacts health care costs the most, etc.), and the sides have to be defending a particular position.Do not use examples where the issue is based on opinions or morality. For example, “Should abortion be legal?” is largely a morality question and is not suitable for statistical analysis. Conducting a survey to ask people about their opinions is not the same as analyzing data and making conclusions- you still only have opinions.MethodologyExplain which methodology you will apply. Provide the relevant details. Where will your data come from? How will the results from this methodology answer the question you described above?If you are going to use forecasting, explain how you will do that (which methodology and why) and how you will measure your accuracy. How will the forecast settle the issue?If you do a regression analysis, explain what the dependent and independent variables will be.If you will do hypothesis testing, what will the null and alternative hypothesis be?