CompetencyDetermine and interpret the linear correlation coefficient, and use linear regression to find a best fit line for a scatter plot of the data and make predictions.ScenarioAccording to the U.S. Geological Survey (USGS), the probability of a magnitude 6.7 or greater earthquake in the Greater Bay Area is 63%, about 2 out of 3, in the next 30 years. In April 2008, scientists and engineers released a new earthquake forecast for the State of California called the Uniform California Earthquake Rupture Forecast (UCERF).As a junior analyst at the USGS, you are tasked to determine whether there is sufficient evidence to support the claim of a linear correlation between the magnitudes and depths from the earthquakes. Your deliverables will be a PowerPoint presentation you will create summarizing your findings and an excel document to show your work.Concept being StudiedCorrelation and regressionCreating scatterplotsConstructing and interpreting a Hypothesis Test for Correlation using r as the test statisticYou are given a spreadsheet that contains the following information:Magnitude measured on the Richter scaleDepth in kmUsing the spreadsheet, you will answer the problems below in a PowerPoint presentation.What to SubmitThe PowerPoint presentation should answer and explain the following questions based on the spreadsheet provided above.Slide 1: Title slideSlide 2: Introduce your scenario and data set including the variables provided.Slide 3: Construct a scatterplot of the two variables provided in the spreadsheet. Include a description of what you see in the scatterplot.Slide 4: Find the value of the linear correlation coefficient r and the critical value of r using α = 0.05. Include an explanation on how you found those values.Slide 5: Determine whether there is sufficient evidence to support the claim of a linear correlation between the magnitudes and the depths from the earthquakes. Explain.Slide 6: Find the regression equation. Let the predictor (x) variable be the magnitude. Identify the slope and the y-intercept within your regression equation.Slide 7: Is the equation a good model? Explain. What would be the best predicted depth of an earthquake with a magnitude of 2.0? Include the correct units.Slide 8: Conclude by recapping your ideas by summarizing the information presented in context of the scenario.Along with your PowerPoint presentation, you should include your Excel document which shows all calculations.

PAPER & EXCELL T BE TURNED IN: ALL ORIGINAL & EXCELL NEEDS TO SHOW PROOF OF WORK Quality at A1 Hotels A1 Hotels operates luxury hotels throughout the world. Recently, motivated by some incidents that appeared in the news, they have been concerned about the quality of service. The company has been giving the following survey to its clients after their stay: How would you rate the quality of your room? Select one.Good(G), Poor(P) How would you rate the quality of your food? Select one.Good(G), Poor(P) How would you rate the quality of your service? Select one.Good (G), Poor(P) Any customer who answered “Poor” to at least one of the three questions up above is considered to be “dissatisfied.” Traditionally, 40% of customers have been dissatisfied.A1 Hotels would like to study customer satisfaction. Therefore, 200 survey responses were recently chosen at random for analysis. The complete data set is in the file named Hotels.Managerial ReportPrepare a report (see Module folder) for A1 Hotels that summarizes your assessment of customer satisfaction. Be sure to include the following seven items in your report. To summarize the data, compute the proportion of all clients that Answered “Poor” to room quality. Answered “Poor” to food quality. Answered “Poor” to service quality. Develop the 92% confidence interval for the proportion of all recent clients that were “dissatisfied.” What is the margin of error? What are the lower (or left) and upper (or right) endpoints of the confidence interval? Interpret your results. Develop the 92% confidence interval for the proportion of all recent clients who answered “Poor” to room quality. What is the margin of error? What are the lower (or left) and upper (or right) endpoints of the confidence interval? Interpret your results. Develop the 92% confidence interval for the proportion of all recent clients who answered “Poor” to food quality. What is the margin of error? What are the lower (or left) and upper (or right) endpoints of the confidence interval? Interpret your results. Develop the 92% confidence interval for the proportion of all recent clients who answered “Poor” to service quality. What is the margin of error? What are the lower (or left) and upper (or right) endpoints of the confidence interval? Interpret your results. Conduct a hypothesis test (using either the p-Value Approach or the Critical Value Approach) to determine if the proportion of all recent clients is more dissatisfied than the traditional level of dissatisfaction. Use α = 0.08. Do not forget to include the correctly worded hypotheses and show all the steps required to conduct the hypothesis test. What advice would you give to A1 Hotels based upon your analysis of the data? What is the magnitude of the issue? How can this study be improved? Write a report that adheres to the Written Assignment Requirements under the heading “Expectations for CSU-Global Written Assignments” found in the CSU-Global Guide to Writing and APA Requirements (Links to an external site.)Links to an external site.. As with all written assignments at CSU-Global, you should have in-text citations and a reference page. An example paper is provided in the MTH410 Guide to Writing with Statistics. (link provided in the Modules tab)Submit your Excel file in addition to your report.Requirements: Paper must be written in third person. Your paper should be four to five pages in length (counting the title page and references page) and cite and integrate at least one credible outside source. The CSU-Global Library (Links to an external site.)Links to an external site. is a great place to find resources. Include a title page, introduction, body, conclusion, and a reference page. The introduction should describe or summarize the topic or problem. It might discuss the importance of the topic or how it affects you or society as a whole, or it might discuss or describe the unique terminology associated with the topic. The body of your paper should answer the questions posed in the problem. Explain how you approached and answered the question or solved the problem, and, for each question, show all steps involved. Be sure this is in paragraph format, not numbered answers like a homework assignment. The conclusion should summarize your thoughts about what you have determined from the data and your analysis, often with a broader personal or societal perspective in mind. Nothing new should be introduced in the conclusion that was not previously discussed in the body paragraphs. Include any tables of data or calculations, calculated values, and/or graphs associated with this problem in the body of your assignment. Document formatting, citations, and style should conform to the CSU-Global Virtual Library CSU-Global Guide to Writing and APA: Introduction (Links to an external site.)Links to an external site.. A short summary containing much that you need to know about paper formatting, citations, and references is contained in the New Sample APA Paper (Links to an external site.)Links to an external site.. In addition, information in the CSU-Global Virtual Library under the Writing Center/APA Resources tab (Links to an external site.)Links to an external site. has many helpful areas (Writing Center, Writing Tips, Template & Examples/Papers & Essays, and others).