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: 2, 45, 34, 25, 6, 45, 67, 89. Using Excel's statistical functions, complete the following:

a. Calculate the simple mean.

b. Calculate the standard deviation.

c. Calculate the median.

d. 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****** You are given the following data set: 5000, 6524, 8524, 7845, 2100,...

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:

Explain the technique for a small service firm setting an hourly price.

Q:

Consider the linear programming model in Prob. 4.5-4. (a) Construct the primal-dual table and the dual problem for this model. (b) What does the fact that Z is unbounded for this model imply about...

Q:

a . Fair value changes are not recognized in the accounting records. Measurement principle ( historical cost ) b . Financial information is presented so that investors will not be misled. Full...

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...