CompetencyDetermine the linear correlation and regression equation between two variables to make predictions for the dependent variable.Student Success CriteriaView the grading rubric for this deliverable by selecting the “This item is graded with a rubric” link, which is located in the Details & Information pane.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.Concepts 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 kmWhat to SubmitThe PowerPoint presentation should answer and explain the following questions based on the spreadsheet provided above.Slide 1: Title slide Slide 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.

Question 25, 33,37

Answers must be entered in Excel with work shown6. Determine the present values if $5,000 is received in the future (i.e., at the end of each indicated time period) in each of the following situations:a. 5 percent for ten years b.7 percent for seven years c.9 percent for four years 9. Assume you are planning to invest $5,000 each year for six years and will earn 10 percent per year. Determine the future value of this annuity if your first $5,000 is invested at the end of the first year. 10. Determine the present value now of an investment of $3,000 made one year from now and an additional $3,000 made two years from now if the annual discount rate is 4 percent. 11. What is the present value of a loan that calls for the payment of $500 per year for six years if the discount rate is 10 percent and the first payment will be made one year from now? How would your answer change if the $500 per year occurred for ten years? 12 Determine the annual payment on a $500,000, 12 percent business loan from a commercial bank that is to be amortized over a five-year period. 13 Determine the annual payment on a $15,000 loan that is to be amortized over a four-year period and carries a 10 percent interest rate. Also prepare a loan amortization schedule for this loan. 15 Assume a bank loan requires an interest payment of $85 per year and a principal payment of $1,000 at the end of the loan's eight-year life.a. At what amount could this loan be sold for to another bank if loans of similar quality carried an 8.5 percent interest rate? That is, what would be the present value of this loan? b.Now, if interest rates on other similar-quality loans are 10 percent, what would be the present value of this loan? c. What would be the present value of the loan if the interest rate is 8 percent on similar-quality loans?