Explain the chain of analysis from payroll

Assignment Help Microeconomics
Reference no: EM13762606

Procedure

A. Use all available NHL team payroll, income-expense, and total points data from the 2001-2002 season to the 2011-2012 season (You should have 10 years, the 04-05 season was cancelled). For each year where all data are available, produce a separate MSExcel spreadsheet for each year with the following columns: team name, total points, payroll, and revenue (this is overall revenue (Revenue $mil) from the income-expense file, not TV revenue). Convert payroll and revenue to $millions for charting.

B. Sort the data by payroll in ascending order. For each year, produce a separate scatter chart with payroll on the x-axis and total points on the y-axis. Calculate the simple correlation between total points and payroll for each year.

C. Using the same spreadsheets, sort the data by total points in ascending order. For each year, produce a separate scatter chart with total points on the x-axis and revenue on the y-axis. Calculate the simple correlation between total points and revenue for each year.

Hand In

Hard copy of all MSExcel files, tables, and charts created, plus a paragraph for each of the following questions:

1. Explain the chain of analysis from payroll to total points (in part B) and then on to total points and revenue (in part C). What other factors might affect these relationships that are outside of the data looked at in this project?

2. In part B, what do the graphs tell you about the relationship between payroll and total points? Do the simple correlation statistics add any more information about this relationship? Explain.

3. In part C, what do the graphs tell you about the relationship between total points and revenue? Do the simple correlation statistics add any more information about this relationship? Explain.

Reference no: EM13762606

What is possible reason china was importing so much silver

During the 1725 - 1750 time period, assume there is a population boom in China, thereby greatly increasing output.  Knowing that the Quantity of Money supplied  = k * PY in

What drives excessive technology investments in each model

Explain how either the Newhouse model or the Physician Workshop model could explain why hospitals might inefficiently over-invest in expensive, new technologies. What drives

How will these events impact the equilibrium price

You are the manager of a firm that produces and markets a generic type of soft drink in a competitive market. In addition to the large number of generic products in your marke

Exlplain the rule of 70

Apply the rule of 70 to solve the following problem. Real GDP per person in Mexico in 2005 was about $12,000 per person, while it was about $48,000 per person in the United

Find the probability that the sample mean x bar

Normal 0 false false false EN-US X-NONE X-NONE

Purchasing and supply management function

Describe what you would do at the first day of your job in a purchasing and supply management function - Describe kinds of information and data that you believe would help yo

The second picture shows the available options

The first picture is just the question. The second picture shows the available options to move point A. The third and fourth pictures show where the line is able to move to. I

What is the autarky or no trade price of motorbikes

U.S. : P = 8 - 1/10 QD P = 4 + 1/10 QS (or, QD = 80 - 10 P and QS = -40 + 10 P)ROW: P = 8 - 1/10 QD P = 2 + 1/10 QS (or, QD = 80 - 10 P and QS = -20 + 10 P)What is the autarky

Reviews

Write a Review

 
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