Problem Set 1 Please note that when you work on quantitative assignments Question Problem Set 1 Please note that when you work on quantitative assignments like statistics, you are expected to get the correct numerical answers. If you get these answers, you will earn an 85. You can earn an A by thorough explanation of the problems and solutions. 1. Basic Business Math: a. A new yarn shop wants to apportion their investment money ($120,000) for advertising, building upgrades, and education in the ratio of 7:8:9. How much money does each category get apportioned? b. CatCo has a new line of kitten starter kits. The basic kit features a sandbox, sand, scooper, three cans of kitten food, and catnip. The exotic kit features the premium self-cleaning sandbox with all natural sand, 6 cases of kitten food, a living catnip plant, and a scratching post tower. The basic kit costs $25 and the exotic kit costs $130. Kitten lovers bought 12 times as many basic kits than exotic kits last month. Last month, both types of starter kit had total sales of $15,480 (this is the total for both items). How many basic kits did CatCo sell? How many exotic kits did CatCo Sell? 2. Create an Excel spreadsheet that can be used to calculate your grade in this class. The spreadsheet should include the weights of each graded assignment, your grade in each assignment, and your final grade. To use this for your benefit you may want to design it so that it can be used to calculate your interim grade before you have all the grades. Use Excels built-in functions to build the calculator so that Excel will automatically calculate your grade as you enter your grades during the class. You do not need to enter any grades, just enter the functions. Use a new sheet called Grade Calculator in the same Excel file that you are submitting for this assignment. After this week you will receive the solution from your professor and you will be able to use our solution for future classes. 3. An essential property of concern for any food company that uses a high-speed bottle-filling machine to package their product is the weight of the food product in the individual bottles. If the bottles are under filled, two problems arise. First, customers may not have enough product for their needs. Second, the company may be in violation of the truth-in-labeling laws. In this example, the label weight on the package indicates that, on average, there are 2.5 ounces of product in a bottle. If the average amount of product in a bottle exceeds the label weight, the company is giving away product. Getting an exact amount of product in a bottle is problematic because of variation in the temperature and humidity inside the factory, differences in the density of the product, and the extremely fast filling operation of the machine (approximately 450 bottles per minute). The following table provides the weight in ounces of a sample of 60 bottles produced in one hour by a single machine: 3.01 3.06 2.45 2.06 2.02 2.59 2.78 3.08 3.08 3.04 2.06 2.47 2.96 2.41 2.48 2.29 2.71 3.09 1.98 3.05 2.91 2.2 1.88 2.8 2.42 2.41 1.98 2.29 2.59 2.52 3.0 1.98 1.79 1.99 1.38 3.06 2.89 3.04 3.27 2.52 3.24 3.03 1.89 2.39 1.43 2.32 2.09 2.89 1.81 3.08 3.01 3.11 1.59 1.81 3.02 2.99 3.01 1.81 3.01 2.33 Compute the arithmetic mean and median. Compute the first quartile and third quartile. Compute the range, interquartile range, variance, standard deviation, and coefficient of variation. Interpret the measures of central tendency within the context of this problem. Why should the company producing the bottles be concerned about the central tendency? Interpret the measures of variation within the context of this problem. Why should the company producing the bottles be concerned about variation? 4. A well known apple juice production company maintains records concerning the number of unacceptable containers of apple juice obtained from the filling and capping machines. Based on past data, the probability that a container came from machine I and was nonconforming is 0.035 and the probability that a container came from machine II and was nonconforming is 0.02. These probabilities represent the probability of one container out of the total sample having the specified characteristics. Half the containers are filled on machine I and the other half are filled on machine II. If a filled container of juice is selected at random, what is the probability that it is an acceptable container? If a filled container of juice is selected at random, what is the probability that it was filled on machine II? If a filled container of juice is selected at random, what is the probability that it was filled on machine I and is an acceptable container?