Determine and interpret the linear correlation coefficient

Assignment Help Microeconomics
Reference no: EM131973655

Competency Assignment

Determine 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.

Scenario

According 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 Studied

• Correlation and regression
• Creating scatterplots
• Constructing and interpreting a Hypothesis Test for Correlation using r as the test statistic

You are given a spreadsheet that contains the following information:

• Magnitude measured on the Richter scale
• Depth in km

Using the spreadsheet, you will answer the problems below in a PowerPoint presentation.

What to Submit

The 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.

Attachment:- Data-Spreadsheet.rar

Reference no: EM131973655

Questions Cloud

Multimillion-dollar salaries : Some people argue that it is wrong for CEOs to earn multimillion-dollar salaries while some of their employees are earning the minimum wage or being laid off
Perform regression analyses to regress Price against Mileage : Using Excel, perform three regression analyses to regress Price against Mileage, then against Age, then against both of them simultaneously
Company approach to global expansion : 1. You are probably a Facebook "friend." What is your opinion about how it is used in your country?
Compiled marketing plan for your fictional start-up company : During this course, you have compiled a marketing plan for your fictional start-up company. Share with your fellow classmates the most important part.
Determine and interpret the linear correlation coefficient : Determine and interpret the linear correlation coefficient, and use linear regression to find a best fit line for a scatter plot of data and make predictions.
Grievance procedure for the redressal of grievances : Define the term 'Grievance'. Also explain the Model Grievance Procedure for the redressal of grievances.
What are the main effects-problems with a currency conflict : What are the main effects/problems with a currency conflict? How or when can country be identified as a currency manipulator?
What are some benefits of ethical behavior : a. What are some benefits of ethical behavior?
Why is the strategic time frame shorter : It seems that strategic plans seem to address a time frame of about 5-7 years. Why is the strategic time frame shorter now as oppose to a period of about.

Reviews

Write a Review

Microeconomics Questions & Answers

  The free rider problem

Question: Explain why the free rider problem makes it difficult for perfectly competitive markets to provide the Pareto efficient level of a public good.

  Failure of the super committee is good thing for economy

Some commentators have argued that the failure of the “Super committee” is good thing for the economy?  Do you agree?

  Case study analysis about optimum resource allocation

Case study analysis about optimum resource allocation: -  Why might you suspect (even without evidence) that the economy might not be able to produce all the schools and clinics the Ministers want? What constraints are there on an economy's productio..

  Fixed cost and vairiable cost

Questions:  :   Which of the following are likely to be fixed costs and which variable costs for a chocolate factory over the course of a month?  Explain your choice.

  Problem - total cost, average cost, marginal cost

Problem - Total Cost, Average Cost, Marginal Cost: -  Complete the following table of costs for a firm.  (Note: enter the figures in the  MC   column  between  outputs of  0 and 1, 1 and 2, 2 and 3, etc.)

  Oligopoly and demand curve problem

Problem based on Oligopoly and demand curve,  Draw and explain the demand curve facing each firm, and given this demand curve, does this mean that firms in the jeans industry do or do not compete against one another?

  Impact of external costs on resource allocation

Explain the impact of external costs and external benefits on resource allocation;  Why are public goods not produced in sufficient quantities by private markets?  Which of the following are examples of public goods (or services)? Delete the incorrec..

  Shifts in demand and movements along the demand curve

Describe the differences between shifts in demand and movements along the demand curve. What are the main factors which can shift the demand curve? Explain why they cause the demand curve to shift. Use examples and draw graphs to support your discuss..

  Article review question

Article Review Question: Read the following excerpts from the article "Fruit, veg costs surge' by Todd, Dagwell, published in the Herald on January 25th 2011 and answer questions below:

  Long-term growth, international trade & globalization

Long-term Growth, International Trade & Globalization:- This question deals with concepts such as long-term growth, international trade and globalization. Questions related to trade deficit, trade surplus, gains from trade, an international trade sce..

  European monetary union (emu) in crisis

"Does the economic bailout of Spain and Greece spell the beginning of the end for the European Monetary Union (EMU)?"

  Development game “settlers of catan”

Read the rules of the game, the overview and the almanac for the Development Game "Settlers of Catan"

Free Assignment Quote

Assured A++ Grade

Get guaranteed satisfaction & time on delivery in every assignment order you paid with us! We ensure premium quality solution document along with free turntin report!

All rights reserved! Copyrights ©2019-2020 ExpertsMind IT Educational Pvt Ltd