you have been hired by the San Antonio Spurs to analyze the 2005-2006 season. For each of the 33-36 games, you will need to analyze the following three variables for EACH team: DRB - Number of Defensive Rebounds ORB – Number of Offensive Rebounds 3P – 3 point Field Goals Made Spurs- DRB- 2548
you have been hired by the San Antonio Spurs to analyze the 2005-2006 season.
For each of the 33-36 games, you will need to analyze the following three variables for EACH team:
DRB - Number of Defensive Rebounds
ORB – Number of Offensive Rebounds
3P – 3 point Field Goals Made
Spurs- DRB- 2548
ORB- 851
3P- 524
Opponent - DRB- 2417
ORB- 886
3P- 886
1. Create a Null Hypothesis and Alternative Hypothesis based on the data above. The Hypothesis must be in written form and formula form.
2. Show the Cluster sample in Excel and explain how the data was collected and the data must represent a sample. The sample sizes must be greater than 33-36 games.
3. using Excel, A list of the summary statistics and an interpretation of each and includes the 1) Mean, 2) Variance, 3) Standard Deviation, and two statistical graphs/charts learned in the course including a
4. A confidence interval for the difference and its interpretations at the 95% level. Be sure to give the reason for choosing the confidence level and what it means. elaborate on it fully. explain what new information is revealed from this confidence interval and explain what new decisions will be made by people after seeing this confidence interval. Explain what the level of significance is. explain the ramifications of the population mean difference not lying in the interval after the new decisions are made. Do not make this part read like the answer a homework problem.
Trending now
This is a popular solution!
Step by step
Solved in 3 steps
