Explain the chain of analysis from payroll

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

Questions Cloud

The major danger of hurricanes to coastal areas : The major danger of hurricanes to coastal areas and how has the federal government historically responded.

Write a program where you create a class called bankaccount : Write a program where you create a class called BankAccount. The BankAccount class should contain a String to store the customer name and a double to store the account balance.

Create a successful turnaround : Describe in detail, their organizational renewal strategies to create a successful turnaround. Compare the new corporate strategy to the old. Did it work?

Direct and indirect methods of preparing the statement : Contrast the advantages and disadvantages of the direct and indirect methods of preparing the statement of cash flows. Are both methods acceptable? Which method is preferred by the FASB? Which is more popular with businesses?

Explain the chain of analysis from payroll : Explain the chain of analysis from payroll to total points and then on to total points and revenue and what other factors might affect these relationships that are outside of the data looked at in this project?

Write the psuedocode showing the logic for a program : Write the psuedocode showing the logic for a program that allows a user to enter 12 numbers and then displays them in the reverse order of their entry

Weather anomalies based problem : Define the weather anomaly

Knowledge of accounting concepts and terminology : Why is a knowledge of accounting concepts and terminology useful to anyone in a business activity? Is there a difference between bookkeeping and accounting? Discuss.

Write a program to help a local stock trading company : Write a program to help a local stock trading company automate its systems. The company invests only in the stock market. At the end of each trading day, the company would like to generate and post the listing of its stocks so that investors can s..

User Account

All Pages