Use the data named GDP_2019.xlsx uploaded in the Final Exam…
Use the data named GDP_2019.xlsx uploaded in the Final Exam folder on Blackboard. Use the [Data] table.Step 1: Winsorize variable GDP at the 5% and 95% levels, and label the winsorized variable GDP_WinsorizedNote: use Excel function PERCENTILE.EXC when calculating the 5% and 95% cutoff values. Answer Questions 47-50.What is the mean for GDP_Winsorized?
Read DetailsUse the dataset named Purchase_Orders.xlsx and answer Questi…
Use the dataset named Purchase_Orders.xlsx and answer Questions 15-19. This dataset contains observations for purchase orders. You are interested in identifying some high-risk observations for purchase order amount [PO_Amount] using the Benford’s law analysis. Extract the leading significant digit of [PO_Amount] and compare the distribution with the prediction under Benford’s law. Answer Questions 35-39 using results from your analysis.What is the number of observations in [PO_Amount] with significant leading digit equal to 3?
Read Details