Write the complete regression equation

Assignment Help Financial Accounting

Reference no: EM131152962

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

Reference no: EM131152962

Questions Cloud

How has technological change affected the roles of women : Write an essay reviewing what role have women played in the development of Science/ Engineering and technology. How has technological change affected the roles of women and ideas of gender?

Is abortion morally wrong, or is it morally permissible : Does the fetus have the same moral standing (i.e. require the same moral consideration) as a person, or does the fetus have some different moral standing?

Problem regarding the chi-square distribution : Suppose that x^2 follows a chi-square distribution with 8 degrees of freedom. Compute P( x^ less than or equal to 5 ). Round your answer to at least three decimal places.

State the decision rule : use 0.05 significance level. a. state the null hypothesis HO: H1: B state the decision rule c. compute the value of the test statistic d. estimate the p value e. what is your decision regarding null hypothesis?

Write the complete regression equation : Compute the confidence interval around the mean salary at 95% confidence level - Lower 95% confidence interval - Upper 95% confidence interval,

Find the probability that the first card is a king : Suppose you draw two cards from a standard deck of 52 cards without replacing the first one before drawing the second. Find the probability that the first card is a king and that the second card is an ace?

Define the three health indicators you have selected : Identify the two countries that you are comparing with the United States. Define the three health indicators you have selected for your analysis and explain why you chose them.

Compare a use case description and an activity diagram : Compare a use case description and an activity diagram. Devise a scenario in which you would use a case description, and devise a scenario in which you would use an activity diagram.

Series of experiments with electro-migration : You now conduct a series of experiments with electro-migration at the same 2 temperatures (T1 = 25ο C and T2= 60ο C). The current density at T1 was 2 mA/μm2 and the current density at T2 was 1 mA/μm2.

User Account

All Pages