Business Mathematics, Mean annual salary, total salary, Excel formula

User Generated

xfnppbzna

Mathematics

Description

Copy of Project_2-11.xls
Pull up the tab for high, low, range, Standard deviation.

I need a formula to input in cells D5 through D16 to find the total salary.  thank you. 

Unformatted Attachment Preview

A B C E F G H Chapter 4- Pie Chart 1 2 3 4 1 pt for correct graph, 1 pt for title, 1 pt for legend, 1 pt for %, 1 pt for leader lines, 1 pt for size adjustment. Nebraska Age Distribution for 2000 Age 5 Number 6 Under 5 117.048 7 5 to 9 years 123.445 8 10 to 14 years 128.445 9 15 to 19 years 134.909 10 20 to 24 years 120.331 11 25 to 34 years 223.273 12 35 to 44 years 263.834 13 45 to 54 years 225.754 14 55 to 64 years 141.540 15 65 to 74 years 115.699 16 75 to 84 years 82.543 17 85 years and over 33.953 18 Total 1.710.774 19 20 D Be sure to save your work. 20150617182713copy_of_project_2_11.xlsPie Chart I A 4 B C D Population Growth Year Nebraska Population 1960 1.411.330 6 1970 1.485.333 7 1980 1.569.825 8 1990 1.578.385 9 2000 1.711.263 10 11 12 13 14 15 Year Hall County Population 17 1960 35.757 18 1970 42.851 19 1980 47.690 20 1990 48.925 21 2000 53.534 22 23 24 25 26 27 28 F G 2 pts for line graph, 4 pts for axis labels, 2 pts for title, 2 pts for size adjustment 5 16 E Chapter 4 - Broken Line Graph 1 2 3 Be sure to save your changes 20150617182713copy_of_project_2_11.xlsBroken Line Chart H I J A 5 6 7 8 9 10 11 12 13 14 15 16 C D E F G H I Chapter 4 - Bar Graph 1 2 3 4 B 1 pt for bar graph, 1 pt for title, 1 pt for x axis, 1 pt for y axis, 1 pt for size adjustment GROSS RENT BY NEBRASKA CITIZENS IN 2000 RENT NUMBER OF RENTERS No Cash Rent 12.714 Less than $200 12.512 $200 to $299 16.814 $300 to $499 71.777 $500 to $749 68.270 $750 to $999 17.168 $1,000 to $1,499 5.879 $1,500 or more 2.082 Be sure to save your changes 20150617182713copy_of_project_2_11.xlsColumn Chart J K M A B C D E 1 Project 2 - Chapter 4 Business Statistics 2 1 pt for each formula 3 Mean, Median, and Mode Data Set 1 14 17 23 25 33 42 43 55 55 67 78 88 96 99 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 Data Set 2 10 20 25 30 45 48 50 65 68 70 75 78 85 90 Data Set 3 16 32 53 26 94 14 15 70 86 66 15 30 26 62 Data Set 4 150 175 168 202 105 95 66 105 59 126 174 187 167 185 19 Mean 20 Median 21 Mode 22 23 Be sure to save your work. 20150617182713copy_of_project_2_11.xlsMean, Median, Mode F A 3 Occupation Accountants and Auditors Loan Officers Tax Preparers Computer and Mathematical Occupations Community and Social Services Occupations Sales and Related Occupations Food Preparation and Serving Related Occupations Office and Administrative Support Occupations Payroll and Timekeeping Clerks Human Resources Assistants, Except Payroll and Timekeeping Computer Operators Child Care Workers 22 Highest Lowest Range Standard Deviation Weighted Mean for Average Salary http://www.bls.gov/oes/current/oes251011.htm 23 Be sure to save your work 17 18 19 20 21 C D E Total Salary of those in Occupation Mean Hourly Wage Chapter 4 - High, Low, Range, Standard Deviation 1 pt for each formula Nebraska May 2005 Wages by Occupation 1 2 4 5 6 7 8 9 10 11 12 13 14 15 16 B 20150617182713copy_of_project_2_11.xlsHigh,Low,Range,Stan.Dev Mean Annual Number Employed Salary $54.580 $55.420 $36.110 $57.760 $30.290 $28.710 $16.360 $26.410 $31.060 $31.130 $27.740 $16.150 7.460 2.830 340 20.250 13.090 94.160 75.020 156.580 1.230 1.210 1.210 4.250 $26,24 $26,65 $17,36 $27,77 $14,56 $13,80 $7,87 $12,70 $14,93 $14,97 $13,34 $7,77
Purchase answer to see full attachment
User generated content is uploaded by users for the purposes of learning and should be used following Studypool's honor code & terms of service.

Explanation & Answer


Anonymous
Just the thing I needed, saved me a lot of time.

Studypool
4.7
Trustpilot
4.5
Sitejabber
4.4

Related Tags