Question: For this lab, you will clean and prepare two data sets using the suggested tools, following the subsequent instructions in Part One. In Part Two,
For this lab, you will clean and prepare two data sets using the suggested tools, following the subsequent instructions in Part One. In Part Two, you will analyze the data from Part One and create a memo based on your analysis. Note: This assignment requires the use of the Analysis ToolPak in Excel. If you do not have the Analysis ToolPak on your computer, you will need to use the VDI. Please review the VDI Access area of the course to sign in to the virtual desktop, if you have not already done so. Remember, once you have completed your work, always save your file on your personal OneDrive before exiting the VDI. Part One: Preparing Data for Analysis For Part One, prepare data for use in prescriptive models for analysis. Using Microsoft Excel with the Analysis Toolpak, prepare the two data sets found in the Module Two Lab Template, located in the What to Submit section. The data set provides two different types of data, located on the Raw Data and Solver Data tabs. Open the Excel workbook, select the Raw Data tab, and clean the data for analysis. Specifically, you must address the following rubric criteria: Use the Split Text to Columns function to organize the data into a table. Complete the following: Highlight Column A. Go to the Data tab in the menu bar. Select Text to Columns. Select Delimited. Select Next. Select Comma. Select Next. Select Finish. Identify the data that should be safeguarded. Provide your response in the template. Identify relationships between l
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
