3 Part 2 of 2 5 points eBook Print Required information [The following information applies to the questions displayed below.] Lab Insight: Apply the same steps in Lab 10.3 to the Alt Lab 10.3 Data.xlsx dataset. Required: 1. Perform hypothesis tests to see if selected supply chain KPIs (asset turnover, inventory-to-sales ratio, inventory turnover) are different between Bed, Bath, and Beyond and Target. 2. Create a scatterplot for asset turnover values from 1999 to 2019 for both Bed, Bath, and Beyond and Target. Data: Alt Lab 10-3 Data.xlsx Specify the Question: Are selected supply chain KPIs (asset turnover, inventory-to-sales ratio, inventory turnover) for Bed, Bath, and Beyond and Target different? Analyze the Data: Refer to lab 10.3 in your text for additional instructions and steps. References Answer the following questions based on the details computed. Question Answer 1. Which company holds more inventory to cover sales (on average)? 2. Create a scatterplot of inventory-to-sales for both companies. What does the scatterplot of inventory-to-sales reveal? 3. How many observations were examined for each company? 4. To be significantly different, does the t Stat need to be larger or smaller than the t Critical value? 5. What is the average inventory-to-sales ratio for Target? (Round to 2 decimal places.) Multiple Choice Options for #1 Bed, Bath, and Beyond Neither company has inventory. - Target The ratios are not significantly different between the companies. Multiple Choice Options for #2 Bed, Bath, and Beyond's inventory-to- sales is generally decreasing over time. Bed, Bath, and Beyond's inventory-to- sales is greater than Target' s inventory- to-sales ratio. Bed, Bath, and Beyond's inventory-to- sales ratio is lower than Target's over the time period. The inventory-to-sales ratio for Target is No Multiple Choice Options Given For #3 #4 & #5 C

Fig: 1