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