Hello Class, and Happy Monday!USE THE TEMPLATE ATTACHED TO THIS POST RATHER THAN THE TEMPLATE IN ALEKS. THE TEMPLATE INCLUDES INSTRUCTIONS FOR COMPLETING THE DQ.For this DQ, you’ll complete a modified version of Technology Assignment 1 in Lesson 3-1 of the textbook in ALEKS, for which you’ll look at the empirical vs. theoretical probabilities of rolling a given number on a multi-sided die.Download the attached template (“QR 3-1 Tech Template MODIFIED.xlsx”) and follow the instructions in the text box to complete the Excel. In this case, the ALEKS video may not provide that much help. Here is a video I made to help!Here are some additional hints for completing the DQ:Hint #1: The RANDBETWEEN() function used in cell B2 will be invoked each time you make a change in the Excel sheet, so your Frequency and Empirical Probability column entries in E2:F16 will keep updating as you change the worksheet. This is normal.Hint #2: Use these steps to copy and paste the contents of cells E2:F16 by value:Select the range of cells E2:F16, then press Copy.Now right-click in the top-left cell that you’ll be copying to (either D21 or F21), and then select the “By Value” option (the clipboard with “123” underneath it) from the Paste Options section of the right-click menu.Once you have copied-and-pasted the cell contents, the values in the cells that you’re copying to should no longer change.Here’s a link to a video that may also help with this: https://www.youtube.com/watch?v=PbRQBse3Ob0.Hint #3: For your response comparing the empirical probability with 1,000 rolls against the empirical probability with 4,000 rolls, what you should do is compare each set of empirical probabilities against the theoretical probabilities in cells G2:G16. Which group of empirical probabilities is, on average, closer to the theoretical probabilities? (How would you be able to quantify “closer” in this case?) How might the number of rolls be contributing to this result?I hope this helps; feel free to let me know if you have any questions.

1.Solve. Round to the nearest tenth of a percent. The graph below shows the number of passports, in millions, issued to U.S. citizens each year from 2007 to 2010. Find the percent decrease in the number of passports issued from 2007 to 2009. %2. Solve. Round to the nearest tenth of a percent. Use the news clipping below to find the percent decrease in the number of people who took the LSATs in the last three years. %3. Solve. Round to the nearest tenth of a percent. The table below shows the number of millionaire households in the United States for selected years. Find the percent increase in the number of millionaire households from 1997 to 2010. %4. Solve. Round to the nearest tenth of a percent. In 1924, the number of events in the Winter Olympics was 14. The 2010 Winter Olympics in Salt Lake City included 86 medal events.† Find the percent increase in the number of events in the Winter Olympics from 1924 to 2010. %5. Solve. Round to the nearest tenth of a percent. The graph below shows the number of active-duty U.S. military personnel, in thousands, in 1990 and in 2009.Which branch of the military had the greatest percent decrease in personnel from 1990 to 2009? -navyWhat was the percent decrease for this branch of the service? 6. A mechanic estimates that the brakes of an RV still have 8,000 mi of wear. This amount is 16% of the estimated safe-life use of the brakes. What is the estimated safe-life use of the brakes? (If it is not possible to answer the question with the given information, enter IMPOSSIBLE.)7. 8. See the news clipping below. What percent of the baby boomers living in the United States have some college experience but have not earned a college degree? Round to the nearest tenth of a percent. (If it is not possible to answer the question with the given information, enter IMPOSSIBLE.) %9. The ratio of weight on the moon to weight on Earth is 1:6. If a bowling ball weighs 16 pounds on Earth, what would it weigh on the moon? Round to the nearest hundredth of a pound. lb10. One way biologists measure a wildlife population is by capturing a certain species of animal, tagging it, and then releasing it back into the wild. Suppose a biologist captures 100 trout from a lake, tags them, and releases them back into the water. One month later, the biologist captures 50 trout from the same lake and finds that 6 trout have tags. Based on this information, approximate the number of trout in the lake. (Round your answer to the nearest whole number.) trout11.Write a true proportion in which the cross products are equal to 36.12. A house with an original value of $140,000 increased in value to $180,000 in 5 years. What is the ratio of the increase in value to the original value of the house?13. NCAA statistics show that of about 3750 college seniors playing college basketball, about 45 will play as rookies in the National Basketball Association. Write the ratio of the number of National Basketball Association rookies to the number of college seniors playing basketball. 14. In a recent year, women spent $2 million on swimwear and purchased 92,000 swimsuits. During the same year, men spent $500,000 on swimwear and purchased 37,000 swimsuits.† Write the ratios as fractions in simplest form.(a) Find the ratio of the amount men spent on swimwear to the amount women spent on swimwear. (b) Find the ratio of the amount men spent on swimwear to the total amount men and women spent on swimwear.15. Using the data in the news clipping below and the figure 110 million for the number of adult males in the United States, write the ratio of the number of men who participated in Movember to the number of adult males in the U.S. Write the ratio as a fraction in simplest form.