Question

In: Statistics and Probability

Using the below data, compare the average salary in 1999-2000 by region to 2014-15 by region....

Using the below data, compare the average salary in 1999-2000 by region to 2014-15 by region. Which groups had statistically significant increases? Decreases? Please use excel to solve and show the steps.  

Average Salary by Region:

Northeast South Midwest West
1999-00 45,312 39,424 38,188 38,604
2014-15 65,559 54,998 52,666 54,440

Solutions

Expert Solution

We have,

Northeast South Midwest West
1999-00 45,312 39,424 38,188 38,604
2014-15 65,559 54,998 52,666 54,440

We can get the increase in salary by subtracting salary from 1999-00 from 2014-15 of each region

For ex. For Northeast, 65559 - 45312 = 20247 and so on. Thus, we get

Northeast South Midwest West
1999-00 45,312 39,424 38,188 38,604
2014-15 65,559 54,998 52,666 54,440
Change 20,247 15,574 14,478 15,836

To get the percentage increase divide the change by 1999-00 salary and multiply by 100

For ex. For Northeast, %change = 20247/45312 * 100 % = 44.68% and so on. Thus, we get

Northeast South Midwest West
1999-00 45,312 39,424 38,188 38,604
2014-15 65,559 54,998 52,666 54,440
Change 20,247 15,574 14,478 15,836
% Change 44.68353 39.5 37.9124 41.02

Northeast group has maximum increase in salary(44.68%) and Midwest has minimum increase in salary(37.91%)

orchestra answered 1 year ago
Next > < Previous

Related Solutions

Fruit prices and the amounts consumed for 2000 and 2014 are below. Use 2000 as the...
Fruit prices and the amounts consumed for 2000 and 2014 are below. Use 2000 as the base.    2000 2014   Fruit Price Quantity Price Quantity   Bananas (pound) $ 0.23 100 $ 0.31 114   Grapefruit (each) 0.27 50 0.34 58   Apples (pound) 0.35 85 0.36 85   Strawberries (basket) 1.04 8 1.41 12   Oranges (bag) 0.88 6 1.01 7 a. Determine the simple price indexes. (Round your answers to 2 decimal places.)   Item Simple index   Bananas         Grapefruit         Apples         Strawberries...
Eastern vs. Western States’ Spending on K-12 Education in 2014 Using the data below, compare how...
Eastern vs. Western States’ Spending on K-12 Education in 2014 Using the data below, compare how much the states East of the Mississippi spend on their K-12 students with how much states West of the Mississippi spend on their K-12 students. Make sure to create a numerical display (make a picture!), describe each distribution (in terms of shape, center and spread) and answer the question: who spends more? Data in Desmos (Links to an external site.). Eastern State $ per...
Eastern vs. Western States’ Spending on K-12 Education in 2014 Using the data below, compare how...
Eastern vs. Western States’ Spending on K-12 Education in 2014 Using the data below, compare how much the states East of the Mississippi spend on their K-12 students with how much states West of the Mississippi spend on their K-12 students. Make sure to create a numerical display (make a picture!), describe each distribution (in terms of shape, center and spread) and answer the question: who spends more? Data in Desmos (Links to an external site.). Eastern State $ per...
Using the data below for the Ace Guitar Company: A Region B Region Sales $955,500 $514,500...
Using the data below for the Ace Guitar Company: A Region B Region Sales $955,500 $514,500 Cost of goods sold 363,100 195,500 Selling expenses 229,300 123,500 Service department expenses Purchasing $247,000 Payroll accounting 164,600 Allocate service department expenses proportional to the sales of each region. Determine the divisional income from operations for the A and B regions. For interim calculations, round percentages to one decimal place. A Region $ B Region $
Use the data below to compute 2014 FCF (Free Cash Flow): 2014 2013 Cash 15 18...
Use the data below to compute 2014 FCF (Free Cash Flow): 2014 2013 Cash 15 18 Short-term investments 10 68 Accounts receivable 368 318 Inventories 551 418 Property, plant & equipment (net) 925 872 Accounts payable 46 32 Short-term debt 95 64 Accrued liabilities 149 135 Long-term debt 662 582 Common stock 130 130 Retained earnings 771 712 Net revenue 3148 2854 Depreciation expense 111 91 Interest 88 62 Taxes 80 82 Net income 255 123 (Round to the nearest...
The data below is from a small group of third graders. Using the data, compare whether...
The data below is from a small group of third graders. Using the data, compare whether there are differences in energy expenditure (average METs/day) in 10 third graders between a day with physical education (w/PE) and a day without physical education (w/o PE). Perform each of the calculations and/or answer each of the questions as indicated. Subject Day w/PE (x1) Day w/o PE (x2) 1 2.1 2.1 2 2.1 1.6 3 2.6 2.5 4 2.1 1.9 5 2.7 2.6 6...
For Problems 1-3, the average annual salary of a Certified Public Accountant (CPA) in one region...
For Problems 1-3, the average annual salary of a Certified Public Accountant (CPA) in one region is $87,000 with a standard deviation of $6300. 3. Suppose that a random sample of 36 CPAs has the same mean as the regional average. Find the probability that the sample mean is less than $85,500.
For Problems 1-3, the average annual salary of a Certified Public Accountant (CPA) in one region...
For Problems 1-3, the average annual salary of a Certified Public Accountant (CPA) in one region is $87,000 with a standard deviation of $6300. 1. Find the probability that a randomly selected CPA makes more than $105,000. Use a bell curve to display the probability area.
For Problems 1-3, the average annual salary of a Certified Public Accountant (CPA) in one region...
For Problems 1-3, the average annual salary of a Certified Public Accountant (CPA) in one region is $87,000 with a standard deviation of $6300. 1. Find the probability that a randomly selected CPA makes more than $105,000. Use a bell curve to display the probability area.
Below are the quality costs data for a company for 2014 & 2015 2014 2015 Prevention...
Below are the quality costs data for a company for 2014 & 2015 2014 2015 Prevention $90,000 $110,000 Appraisal $50,000 $62,000 Internal Faliure $40,000 $34,000 External Faliure $62,000 $60,000 Sales: $5,100,000 $5,350,000 A) whats the precentage change in the total quality index between 2014 & 2015 B) What is the percentage change in the precention quality index between 2014 & 2015 C) What is the percentage change in the internal faliure quality index between 2014 & 2015 ? D) Do...
ADVERTISEMENT
Subjects
ADVERTISEMENT
Latest Questions
ADVERTISEMENT