World112-1_TK_04
Management Consulting Quantitative CalculationCan you please calculate the z score of US 2024 Average Monthly Revenue per Head, for all of Impact’s sites?
Use a distribution of US 2024 Average Monthly Revenue per Head per site for all the sites in the attached file, which has the monthly US operational data for all of Impact’s and competitor’s sites. You can allocate the yearly revenue from the respective P&L equally across all the respective sites and months.
Tell me here the z score of only the Impact site with the highest absolute z score, and the SiteID of this Impact site. Use the standard deviation formula for sample, not population. Round the final answer to two decimal places. Write back to me with what I've asked for.
Input Files
1 fileYour Answer
Expected: Text Response
0 / 12,000
chars
Cmd/Ctrl+Enter to submit & evaluate
Evaluation
Submit your answer to see evaluation results.