Question: *****CAN YOU PLEASE PUT THE ANSWER STEP BY STEP IN AN EXCEL FILE I want to know how to do it on an excel spreadsheet

*****CAN YOU PLEASE PUT THE ANSWER STEP BY STEP IN AN EXCEL FILE I want to know how to do it on an excel spreadsheet please******

  1. You are given the following data set: 5000, 6524, 8524, 7845, 2100, 9845, 1285, 3541, 4581, 2465, 3846.

Using Excel's statistical functions, complete the following:

  1. Calculate the simple mean.

  1. Calculate the standard deviation.

  1. Calculate the median.

  1. Is the median equal to the mean? Why or why not?

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 General Management Questions!

Q:

*****CAN YOU PLEASE PUT THE ANSWER STEP BY STEP IN AN EXCEL FILE I want to know how to do it on an excel spreadsheet please****** SamanthaandSabrinaareopeningasodastand. Theybelievethefixedcost per...

Q:

*****CAN YOU PLEASE PUT THE ANSWER STEP BY STEP IN AN EXCEL FILE I want to know how to do it on an excel spreadsheet please****** 1. You are given the following data set: 2, 45, 34, 25, 6, 45, 67,...

Q:

*****CAN YOU PLEASE PUT THE ANSWER STEP BY STEP IN AN EXCEL FILE I want to know how to do it on an excel spreadsheet please****** Chad Holmes has been thinking about starting his own independent...

Q:

*****CAN YOU PLEASE PUT THE ANSWER STEP BY STEP IN AN EXCEL FILE I want to know how to do it on an excel spreadsheet please****** 6. It is the first day of pheasant season and Frank is getting ready...

Q:

*****CAN YOU PLEASE PUT THE ANSWER STEP BY STEP IN AN EXCEL FILE I want to know how to do it on an excel spreadsheet please****** The following are numerical statistics for five data sets. Using...

Q:

10. The VA-TX Company has noticed when it advertises, it dramatically increases the amount of customers who buy its product at seminars. With advertising, VA-TX expects the audience to buy the...

Q:

*****CAN YOU PLEASE PUT THE ANSWER STEP BY STEP IN ANEXCEL FILE I want to know how to do it on an excel spreadsheetplease****** 6. The following data were collected on scores (out of a possible 100)...

Q:

Please put the answer in a word document or excel spreadsheet. Thank you - see attached file first. Calculate the expected return and standard deviation of for single stocks and portfolio You have...

Q:

please please please help Your company will be a small manufacturing/wholesale business that rents a Business Unit that has both a production and an administration area. The company will make the...

Q:

Please help, answer must be in a Excel File... Let me know frequent Please submit all answers in an Excel file. Problem: QQQ Investment A. Assume the following facts and assumptions: 1. QQQ ETF and...

Q:

List and discuss three ways to ensure the overall quality of a structure chart.

Q:

Jennifer flew from Tallahassee to Arizona for a 4 day conference related to her business. She stayed an extra 3 days to go sightseeing. Her trip expenses were: Airfare $590 Hotel (7 days x $200)...

Q:

Sandra is 5 8 years old and lives with her son, John. Sandra received $ 2 0 0 , 0 0 0 in insurance proceeds after her spouse's death. She wishes to leave this amount to John after her death. She...

Q:

As the manager of Smith Construction, you need to make a decision on the number of homes to build in a new residential area where you are the only builder. Unfortunately, you must build the homes...