Please help to Replicate each calculations below that can be put in excel

VISUALIZATION AND MEASURES OF CENTRAL TENDENCY 1. Histograms

2. Use the cell function "=average" and "=median" to generate the mean and median score for Mr. Predictable and Mr. Unpredictable.

2. Generate a descriptive statistics table from the Data Analysis (DATA / DATA ANALYSIS). Ensure that the values from the descriptive statistics table agree with those from the cell function calculations developed in step 1.

MEASURING THE VARIABILITY IN THE DATA 1. Use the bowling data. Calculate the variance and standard deviation using the EXCEL cell functions (VAR Function and STDEV function)

2. Ensure that the variance and standard deviation calculated in item 1 agree with the variance and standard deviation provided by the from the Descriptive Statistics tool in the EXCEL DATA TOOLPAK.

DIVIDING DATA FOR ANALYSIS 1. Develop quartiles and deciles for the S&P 500 Market Values

NORMALIZING DATA FOR DECISION MAKING

See the data in the "Coat Sales" tab in the EXCEL student data file. North Trace sells winter coats. You are the Sales Manager with responsibility for two markets: The Upper Midwest headquartered in Chicago and the Southwest headquartered in Los Angeles. You are evaluating your most talented sales persons. Their sales are shown in the EXCEL spreadsheet. Required: 1. Make the empirical case for the top five sales persons in your employ. 2. One sales person is going to be moved out of sales and into the warehouse shipping operations. You do not want this to be one of the talented sales persons. Each of your sales persons is equally able to perform the shipping operations function. Who should be transferred?

A CLOSER LOOK AT THE NORMAL DISTRIBUTION (BELL CURVE)

See the bell curve that represents the bowling scores of Mr. Consistency and Mr. Unpredictable 1. Identify the mean 2. Discuss one standard deviation away from the mean 3. Discuss two standard deviations away from the mean 4. What does it mean to be in the right tail of the distribution? 5. What does it mean to be in the left tail of the distribution? 6. What is the cumulative probability?

RELATIONSHIP BETWEEN TWO VARIABLES

See the "Two Variables (GPA and ACT +)" tab in the data file 1. Create a scatter diagram for GPAs and ACT Scores 2. Create a scatter diagram for GPAs and Absences 3. Does there appear to be a relationship between the two variables? If so, which variable is at least somewhat dependent upon the value of the other variable?

SEE THE TWO VARIABLES (GPA AND ACT +) TAB: 1. Calculate the Correlation Coefficient for two variable sample ACT Score and GPA Absences and GPA