Question: Described a current problem you are facing at work and how you might design a spreadsheet model to solve it. Also, describe the data set
Described a current problem you are facing at work and how you might design a spreadsheet model to solve it. Also, describe the data set you would need to create the spreadsheet model to solve the problem. You will also apply the data exploration process from Section 5.4 Data Exploration in the Powell text. The process is:
Understand the data Organize and subset the data Examine individual variables graphically Calculate summary measures for individual variables. Examine relationships among variables graphically Examine relationships among variables numerically Think about the problem you discussed during the Week Two discussion. Describe how you understand the data. Describe how you would organize and subset the data. Explain which variables you would examine graphically, and why. Explain which summary measures you would calculate for which variables. Describe which variable relationships you would examine graphically and numerically. Your student responses should focus on asking clarifying questions, or suggesting ways to improve the model. Consult the discussion forum rubric for further details.
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
