FST Chapter 7: Probability and Simulation There are 27 questions from the Chapter Review on pages 482-485 of our textbook (see attachments). **Helpful tip: There are answers to the odd numbered questions in the back of the textbook. Use these to help you make sure you are on the right track for the questions on the assignment (see attachments). At the end of the assignment, there are an additional 10 questions that are not from the textbook. Show your work and circle your answers for each question below. If your answer is not correct I will look at your work to see if I can award partial credit. You may attach your work to this as long as you clearly mark which problem is being worked. When you are finished you should scan or take photos of the pages and send back to me. I suggest using the Camscanner app (free version) or a similar program so that you can attach your entire assignment as 1 file. When using this app, select the batch function so that you can take multiple pictures. Please take any photos in bright light so that your answers and work show up clearly - then submit it as a PDF file. It is okay to hand write work/answers, as long as it is clear what work belongs with what question and the answers are circled. The assigned questions are in the attachments.

For Project 4, we are just asking for the sales figures for 2019 and 2020, which is given. Disregard Step 2 in the steps to completion and use the attached documents instead.Step 1: Refresh Your Math, Statistics and Excel Skills Step 2: Set Up Your Spreadsheet Use template Step 3: Add Data In Section 1 on the Data page, complete each column of the spreadsheet to arrive at the desired calculations. When you're ready, move on to the next step, where you will use functions to summarize the data. Step 4: Use Functions to Summarize the Data With this step complete, you’re ready to begin your analysis. Step 5: Analyze the Workforce You will be working in section 3 of the Data tab in the spreadsheet to complete the descriptive statistics for the five categories (Salary, Hourly Rate, Years of Service, Education, and Age). Using Excel formulas, complete the table. After you have used Excel formulas to find this information, you will next use the Toolpak to find your summary statistics. Step 6: Use the Analysis Toolpak you will now use the Analysis Toolpak to do those same functions. This is a handy feature to know. Remember that there may be some minor differences in the answers depending on the version. You should now have Tab 2 complete: Excel Summary Stats. Next, you’ll create charts and a histogram for Tabs 3 and 4 Step 7: Create Charts and a Histogram In this step, you will build Tab 3: Graphs—Charts and Tab 4: Histogram. After you complete these tabs, you’ll be ready to sort the data. Step 8: Copy and Sort the Data In this step, you will create Tab 5: Sorted Data. When you’re finished, you’ll be ready to conduct your quantitative analysis. Step 9: Conduct Quantitative Analysis Apply your quantitative reasoning skills to answer five questions that demonstrate your interpretation of the data. The questions are located on the QR Questions_Responses tab in your workbook. After you have answered the five questions, please finish the project by writing a short essay. Your short essay will include: a one-paragraph narrative summary of your findings, describing patterns of interest an explanation of the potential relevance of such patterns a description of how you would investigate further to determine if your results could be perceived as good or bad for the company. Prepare your responses in your workbook on the QR Questions_Responses tab. Step 10: Submit Your Completed Workbook and Analysis You’re now ready to submit your workbook and analysis for review and feedback. Review the requirements for the final deliverable to be sure you have: Excel Workbook with Six Tabs Tab 1: Data – completed data sheet (Steps 1–6 above) Tab 2: Excel Summary Stats (Step 6) Tab 3: Graphs – Charts (Step 7) Tab 4: Histogram (Step 7) Tab 5: Sorted Data (Step 8) Quantitative Analysis (Step 9; see detail below and move to first position upon completion.) Quantitative Analysis: Answers to Questions and Short Essay Prepare your response in this workbook. Create a tab for Quantitative Analysis, create a text box, and paste your answers to the questions in it. Move the Quantitative Analysis tab to the first tab position. Your final workbook tabs: Quantitative Analysis Data Excel Summary Stats Graphs–Charts Histogram Sorted Data Format to Be Printed Format this workbook so that all the spreadsheets can be printed.