Question: In EXCEL use the formulas = average (range), = median (range) and = st. dev (range) to find the median, average and standard deviation for

In EXCEL use the formulas = average (range), = median (range) and = st. dev (range) to find the median, average and standard deviation for salary and years of education. To find the average of salary go to a cell on the worksheet and enter = average (f2:f475).

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer

Step: 1 Unlock blur-text-image

Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock

Step: 3 Unlock

Students Have Also Explored These Related Research Methods Business Questions!

In Excel use the formulas = average (range), = median (range) and = st.dev (range) to find the median, average and standard deviation for salary and years of education. To find the average of salary...

1 Project Part A Feedbacks from Prof for Project Part A is within. So please avoid making similar mistakes. Introduction 2 The store we are using is AJ Davis which is a department store chain. In...

ID Salary Compa Midpoint Age 4 5 6 7 8 9 10 11 12 13 14 15 19 20 21 22 26 27 30 31 32 43 44 49 50 1 2 3 16 17 18 23 24 25 28 29 33 34 35 36 37 38 39 40 41 42 45 46 47 48 75.4 72 46 26.9 59.8 65.4...

ID Salary Compa Midpoint Age 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 60 26.8 34.7 57.9 48.5 74.3...

ID Salary Compa Midpoint Age 1 2 4 5 6 9 12 16 19 21 25 27 29 30 32 33 34 38 40 41 44 46 47 49 50 3 7 8 10 11 13 14 15 17 18 20 22 23 24 26 28 31 35 36 37 39 42 43 45 48 60.3 27.2 61 47.7 76 74.3...

ID Salary Compa Midpoint Age Performance Service Gender Rating Raise Degree Gender 1 Gr Students: Copy the Student Data file data values into this sheet to assist in doing your weekly assignments....

ID Salary Compa Midpoint Age 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 60.3 27.2 35 61 47.7 76 41...

ID Salary Compa Midpoint Age Performance Service Gender Rating Raise Degree Gender 1 Gr Students: Copy the Student Data file data values into this sheet to assist in doing your weekly assignments....

ID Salary Compa Midpoint Age 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 66.6 26.4 35.3 56 47.5 75.5 41.5 22.8 74 24.1 23.6 63.4 41.4 23 23.6 44.1...

An oscillating current in a electric circuit is described by i = 9e 1 cos(2t), where t is in seconds. Determine all values of t such that i = 3.

A firm has the following balance sheet as of December 31, 2008: ASSET LIABILITIES AND EQUITY Cash $100 Accounts Payable $300 Accounts Receivable 300 Long-term debt 800 Inventory 400 Equity 400 Plant...

In a homeowners policy, Coverage D - Loss of Use will NOT cover: a . loss of rental income if a renter can t stay in the apartment until damages are repaired. b . meals out when a home is damaged and...

What four general-purpose financial statements do business enterprises use?