Excel Worksheet 2-Math 243-Fall 2015 (Total: 25 points) Instructions: Read this very carefully. In one Excel le create two sheets. Label one sheet \"Problem 1\" and label the second sheet \"Problem 2.\" Your solutions to the two problems should be recorded on the corresponding sheet. Additionally, you should clearly label each part of the problems with (a), (b), etc., and every computation should be labeled. For example, in the cell next to the mean of the data, you should have typed the word mean or average. Be sure to do your computations using Excel. Do not do computations using Table A or on a calculator and then type the answers into Excel. 1. The weights of boxes of crackers produced by a certain manufacturer have a Normal distribution with a mean of 255 grams and a standard deviation of 3.5 grams. (a) (4 points) What percent of boxes of crackers weigh more than 260 grams? (b) (4 points) What is the standardized value for a box of crackers that weighs 260 grams? (c) (4 points) What percent of observations from a standard Normal distribution N (0, 1) take values larger than the standardized value from part (b)? (d) (2 points) Are your answers to parts (a) and (c) similar? (Don't simply answer yes or no. Explain how they are or are not similar.) (e) (4 points) What is the weight that should be stamped on each box so that only 1% of boxes are underweight? 2. I want you to go nd data in an article, in a newspaper, or somewhere online. Your data set should have consist of one quantitative variable with values for at least 20 individuals from the population. (NOTE: You do not have to make your own data using a survey. I intend for you to nd data online or elsewhere that someone else collected.) (a) (1 point) Paste the data in column A. (b) (2 points) Describe the population from which the data was obtained. (c) (2 points) What is the quantitative variable? (d) (2 points) Do you have data from the entire population or a sample of the population