please answer the 5 question and based on the data what is return on sales formula?

PDF document when you have reached the final step of the lab. In this lab, you will: Required: 1. Compute descriptive statistics for the sales (net) and income (loss) for the retail industry in 2018. 2. Calculate return on sales (ROS), computed as [Net income (loss) / Sales (net)], and create a histogram showing the performance across the dataset. Ask the Question: What was the distribution of assets and ROA in 2018 for the retail industry? Master the Data: Apply the same steps as Lab 5-1, but now work to compute descriptive statistics for Sales (net) and Income (Loss) data (instead of Total Assets), calculate return on sales, and create a histogram. Software needed - Excel - Screen capture tool (Windows: Snipping Tool; Mac: Cmd+Shift+4) Data: Excel File Lab 5-1 Alt Data.xlsx Perform the Analysis: Refer to Lab 5-1 Alternate in the text for instructions and Lab 5-1 steps for each the of lab parts. Share the Story: Once we have completed the computation of the descriptive statistics and created the histogram, we are ready to show management where the target retail company of interest landed within the distribution for the whole industry. \begin{tabular}{|r|r|r|r|r|r|r|r|r|r|} \hline 158 & 105104 & 20181231 & 2018 WMMVY & 15598.823 & 1870.289 & 31393.703 & 5331 \\ \hline 159 & 11259 & 20180131 & 2017 WMT & 204522 & 9862 & 496785 & 5331 & \\ \hline 160 & 11511 & 20180131 & 2017 WSM & 2785.749 & 259.545 & 5292.359 & 5961 \\ \hline 161 & 65417 & 20181231 & 2018 YUM & 4130 & 1542 & 5688 & 5812 \\ \hline 162 & 162988 & 20180131 & 2017 ZUMZ & 499.51 & 26.802 & 927.401 & 5651 & \\ \hline \end{tabular} Required: 1. What is the mean Net Income for 2018 for the retail industry (\$ millions)? 544.3468,695.322,106.8715,379.43 2. What is the mean Sales (net) for 2018 for the retail industry (\$ millions)? 8,695.3215,379.432,106.87544.346 3. Which is more likely to be negative? Sales (net) or net income? Sales (net) Net Income 4. Which observation is the outlier for return on sales? 0.100.0721.930.29 PDF document when you have reached the final step of the lab. In this lab, you will: Required: 1. Compute descriptive statistics for the sales (net) and income (loss) for the retail industry in 2018. 2. Calculate return on sales (ROS), computed as [Net income (loss) / Sales (net)], and create a histogram showing the performance across the dataset. Ask the Question: What was the distribution of assets and ROA in 2018 for the retail industry? Master the Data: Apply the same steps as Lab 5-1, but now work to compute descriptive statistics for Sales (net) and Income (Loss) data (instead of Total Assets), calculate return on sales, and create a histogram. Software needed - Excel - Screen capture tool (Windows: Snipping Tool; Mac: Cmd+Shift+4) Data: Excel File Lab 5-1 Alt Data.xlsx Perform the Analysis: Refer to Lab 5-1 Alternate in the text for instructions and Lab 5-1 steps for each the of lab parts. Share the Story: Once we have completed the computation of the descriptive statistics and created the histogram, we are ready to show management where the target retail company of interest landed within the distribution for the whole industry. \begin{tabular}{|r|r|r|r|r|r|r|r|r|r|} \hline 158 & 105104 & 20181231 & 2018 WMMVY & 15598.823 & 1870.289 & 31393.703 & 5331 \\ \hline 159 & 11259 & 20180131 & 2017 WMT & 204522 & 9862 & 496785 & 5331 & \\ \hline 160 & 11511 & 20180131 & 2017 WSM & 2785.749 & 259.545 & 5292.359 & 5961 \\ \hline 161 & 65417 & 20181231 & 2018 YUM & 4130 & 1542 & 5688 & 5812 \\ \hline 162 & 162988 & 20180131 & 2017 ZUMZ & 499.51 & 26.802 & 927.401 & 5651 & \\ \hline \end{tabular} Required: 1. What is the mean Net Income for 2018 for the retail industry (\$ millions)? 544.3468,695.322,106.8715,379.43 2. What is the mean Sales (net) for 2018 for the retail industry (\$ millions)? 8,695.3215,379.432,106.87544.346 3. Which is more likely to be negative? Sales (net) or net income? Sales (net) Net Income 4. Which observation is the outlier for return on sales? 0.100.0721.930.29