I need help with these 2 case studies please they are due today.
This is a written, statistical report, not simply a collection of different types of Excel output.It is not necessary to include the formulas you used or a copy of the dataset. When answering the questions, make sure to include any relevant statistics and/or the results of your calculations. Like any other written report, you will want to start with an introductory paragraph or problem statement, and finish with a conclusion that summarizes the information presented.
Your responses should be written in complete paragraphs;bulleted lists are not appropriate.
When answering the questions, make sure to double-check your calculations. It is also important to fully address the question being asked. Be sure to include your results as well as a detailed explanation/interpretation of the information. Statistical analysis includes not just the ability to obtain the correct results, but also the ability to describe and interpret what the results mean. Instead of simply saying, "Variable X has more variation." Use your statistics to support your conclusions, "Variable X has more variation because…"
UNEMPLOYMENT STUDY
Each month the US Bureau of Labor Statistics publishes a variety of unemployment statistics, including the number of individuals who are unemployed and the mean length of time the individuals have been unemployed. For November 1998, the Bureau of Labor Statistics reported that the national mean length of time of unemployment was 14.6 weeks.
The mayor of Philadelphia requested a study on the status of unemployment in the Philadelphia area. A sample of 50 unemployed residents of Philadelphia included data on their age and the number of weeks without a job. A portion of the data collected in November 1998 follows. The complete data set is available in the data file BLS.
Managerial Report
1. Use descriptive statistics to summarize the data.
2. Develop a 95% confidence interval estimate of the mean age of unemployed individuals in Philadelphia.
3. Conduct a hypothesis test to determine whether the mean duration of unemployment in Philadelphia is greater than the national mean duration of 14.6 weeks. Use a .01 level of significance. What is your conclusion?
4. Is there a relationship between the age of an unemployed individual and the number of weeks of unemployment? Explain.
Predicting Winning Percentage for the NFL
The National Football League (NFL) records a variety of performance data for individuals and teams (NFL website). Some of the year-end performance data for the 2005 season appear in the file named NFLStats. Each row of the data set corresponds to an NFL team, and the teams are ranked by winning percentage. Descriptions for the data follow:
WinPct Percentage of games won
DefYds/G Average number of yards per game given up on defense
RushYds/G Average number of rushing yards per game
PassYds/G Average number of passing yards per game
FGPct Percentage of field goals made
TakeInt Takeaway interceptions; the total number of interceptions made by the team’s defense
TakeFum Takeaway fumbles; the total number of fumbles recovered by the team’s defense
GiveInt Giveaway interceptions; the total number of interceptions thrown by the team’s offense
GiveFum Giveaway fumbles; the total number of fumbles recovered by the team’s offense
Managerial Report
1. Use methods of descriptive statistics to summarize the data.Comment on the findings.
2. Develop an estimated regression equation that can be used to predict WinPct using DefYds/G, RushYds/G, PassYds/G, and FGPct. Discuss your findings.
3. Starting with the estimated regression equation developed in part (2), delete any independent variables that are not significant and develop a new estimated regression equation that can be used to predict WinPct. Use α = .05.
4. Some football analysts believe that turnovers are one of the most important factors in determining a team’s success. With Takeways = TakeInt + TakeFum and Giveawasys = GiveInt + GiveFum, let NetDiff = Takeaways – Giveaways. Develop an estimated regression equation that can be used to predict WinPct using NetDiff. Compare your results with the estimated regression equation developed in part (3).