Hypothesis Testing about mean in excel
Budget: $30 – $250 USD
In the "Data" worksheet tab, you'll find the raw data with the variable short-hand name in the top row. Then, each participant's data is presented in the rows below the headings. In the "Variables Key", you'll find the full description or question for each of the short-hand variable labels.
Instructions: Come up with three univariate (single variable) hypotheses about a mean using the Alcohol study data. Each hypothesis should involve a different variable in the dataset. Test the hypothesis in Excel.
Create three Powerpoint slides (one for each hypothesis) a) to present the hypothesis, b) name the question (variable) in the survey, c) describe the analysis conducted, d) present the results of the analysis, and e) interpret the results in language a marketing decision maker would understand. Also, f) include a histogram bar chart for each of the three variables on their corresponding slides.
Instructions: Come up with three univariate (single variable) hypotheses about a mean using the Alcohol study data. Each hypothesis should involve a different variable in the dataset. Test the hypothesis in Excel.
Create three Powerpoint slides (one for each hypothesis) a) to present the hypothesis, b) name the question (variable) in the survey, c) describe the analysis conducted, d) present the results of the analysis, and e) interpret the results in language a marketing decision maker would understand. Also, f) include a histogram bar chart for each of the three variables on their corresponding slides.