Data set and doc will be provided, (the top richest person data set) please follow the question and rubic and crate the excel work and document work.
question 1: based on the dataset provide create a confidence interval. If the variable of interest is categorical, please double-check the answer from Excel’s data analysis toolpak. Interpret the findings.
rubic for question 1 :
– The confidence interval calculation is correct. Reviewers, please check manually as Excel’s analysis can be inaccurate for proportions.
-The interpretation of the interval is correct and meaningful.
Question 2: perform a one-sample hypothesis test on the provided dataset. Interpret the findings.
rubic for question 2:
-The hypothesis test to be used was identified correctly, e.g.,t or z test for numerical data and z test for categorical.
-Interpretation of the results are correct. The student indicated the confidence level for the results.
