q5 suppose the meta_score is normally distributed using the mean and s
Search for question
Question
Q5. Suppose the meta_score is Normally distributed. Using the mean and standard you calculated in Q1, compute the probability that a
random meta_score is greater than 72. Display your answer with two decimal places.
Probability:
0.64 mean
75.93495
st.dev
z score
10.93785
-0.35975
Q6. Compute a p-value for the null hypothesis: the proportion of good games (meta_score >= 80) among Role-palying
games is equal to 15% v.s. the alternative hypothesis: it is different than 15%.
p-value:
Q7. Compute a 95% confidence interval for the meta_score across all game genres.
Confidence interval lower level:
Confidence interval upper level:
Q8. Create a pivot table with the groupings you see below in the frequency table and get the counts. Then use
the frequency formula to fill in the count of Meta Score in the frequency table. The correct answer will have a
pivot table and frequency table with matching counts.
Place pivot table below
Meta Score
Upper limit
Greater than 95
Meta Score Frequency
54
74
94
Q9. On the top 10 rows of the data, use the INDEX MATCH formula to get the title and meta score for the 2D sub
genre.