Logo
Home Study Material Contact Search
AI Chat FREE
  1. mathematics
  2. statistics
  3. using the below data, compare the average salary i

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

Free

80.2K

Verified Solution

Question

Statistics

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

Average Salary by Region:

NortheastSouthMidwestWest
1999-0045,31239,42438,18838,604
2014-1565,55954,99852,66654,440

Answer & Explanation Solved by verified expert
3.6 Ratings (360 Votes)

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%)
Get Answers to Unlimited Questions

Join us to gain access to millions of questions and expert answers. Enjoy exclusive benefits tailored just for you!

Membership Benefits:
  • Unlimited Question Access with detailed Answers
  • Zin AI - 3 Million Words
  • 10 Dall-E 3 Images
  • 20 Plot Generations
  • Conversation with Dialogue Memory
  • No Ads, Ever!
  • Access to Our Best AI Platform: Flex AI - Your personal assistant for all your inquiries!
Become a Member

Other questions asked by students

Algebra
1.2K views

What value of c will complete the square x 3x c O O O O...

Chemistry
1.2K views

when we performed the TLC experiment, the class chose a mixture for the mobile phase of...

Chemistry
1.2K views

Balance each of the following redox reactions occurring in acidic aqueous solution. art A K(s)+Cr3+(aq)→Cr(s)+K+(aq) Express your answer as...

Programming
1.2K views

Introduction In this lab, we will look at various aspects of methods in Java programming such as...

Physics
1.2K views

In Young s double slit experiment the separation between the slits is 4A A is...

Physics
1.2K views

16 If B B and B are the magnetic field due to 1 12 and...

Geometry
1.2K views

Day 1 2 23 3 4 5 Value 3 938 6 891 12 059 21...

Algebra
1.2K views

If the mean number of people who attended four basketball games is 4860 what was...

Accounting
1.2K views

I am unsure of the answer ... I think I know, but I just wanted...

Accounting
1.2K views

When you develop and implement strategies to ensure that difficulties in workplace relationships are identified...

Accounting
1.2K views

At the end of March, the accounting records for Lansing, Inc., revealed a balance for...

Accounting
1.2K views

On the first day of the current fiscal year, $2,000,000 of 10-year, 7% bonds, with...