DESCRIPTIVE
1. Data to the left show a sample of baseball players by various teams and their position.

Compute the following (do not use the data analysis toolpak for Q1). Answers should go in places where they are highlighted or instructed.
You should be computing all these numbers and not typing in the numbers and this goes for all the problems for all the sheets
Always put 4 decimal places for all the problems throughout this application assignment
1. There are a total of 4 main question on this sheet
1 Mean
2 Median
3 Mode
4 Standard Deviation
5 90th Percentile

2. Compute the confidence interval around the mean salary at 95% confidence level
• Lower 95% confidence interval
• Upper 95% confidence interval

3. Using the pivot table, compute the frequency of salary by position and place the TABLE starting in cell G14

4. Using the pivot table, compute the frequency of salary by team. Place the TABLE and the GRAPH starting in cell G45 

CORRELATION

1. Data to the left show sample earnings of 100 golf players from year 2011.
Compute the correlation for each of the following. Do not use the data analysis tool pack

•Age vs Cuts Made
• Age vs Top 10s
• Age vs Driving Accuracy
• Age vs Yards/Drive
• Age vs Earnings

CONTINGENCY ANALYSIS
1.Data to the left shows a sample dataset. This contains the variables gender and if they have tried ABC Corp's new triple layer brownies .

Create a contingency table below (starting in Cell F 20) to determine if there are significant differences between gender and having tried the brownie.

Based on the tables created and shown below by your work answer the following

Define the null and alternative hypothesis below:
• Null
• Alternative
•Chi Sq Statistic
• Chi Sq Probability (95%)
• Chi Critical Value
• What is your conclusion? And Why?

FORECASTING

Place your computations in the appropirate columns with the headings next to the original data

Q1 Based on your computations answer the following

What is the forecasted value for time period 23 using:
• Trend
• Exponential Smoothing
• Moving Average

Q2 Insert a TREND line below using the Charts and show the equation on the chart.

ABC BALANCE SHEET

Place your computations in the appropirate columns with the headings next to the original data.

Q1 Based on your computations answer the following
What is the forecasted value for time period 23 using:

Trend
Exponential Smoothing
Moving Average

Q2 Insert a TREND line below using the Charts and show the equation on the chart

REGRESSION

Q1 Write the complete regression equation below

Q2 What can you infer from the R2 (R square) 

BREAK EVEN ANALYSIS

Q1 Using charts create a break-even analysis. Please the chart starting from Cell H15

Q2 Compute the breakeven quantity

Q3 Compute the breakeven dollar

Attachment:- New-Ass-.rar