Lab #1 One & Two-Population Hypothesis Testing 1) Open Excel and download the Analysis ToolPak if you don't have it: https://support.microsoft.com/en-us/office/load-the-analysis-toolpak-in-excel-6a63e598-cd6d-42e3-9317-6b40ba1a66b4?ui=en- us&rs=en-us&ad=us 2) Download the dataset at D2L Labs tab: "Lab #1 Descriptive Statistics Winery Data" 3) Use the "Selected Countries" worksheet for the data in this lab: 4) Do a One-Population Hypothesis Test a. At a 5% significance level, test for whether the average price of French wine is greater than $44 i. Use the following link for guidance: https://www.youtube.com/watch?v=v-ZcqrdTcIQ 1. Note: Need to insert a blank column next to France prices 2. Shortcut Note: To highlight the entire range (column of numbers) a. In PC: Shift + Ctrl + Down arrow b. In Mac: Shift + Command + Down arrow 5) Do a Two-Population Hypothesis Test a. Test for whether the average price of Australian wine is greater than that of Austrian wine i. Also, use the t-Test: Two-Sample Assum