Complete Case Study -- "Low Nail Company" from our text. Provide a brief discussion of your results for each question. - Provide your answers in a well-formatted EXCEL file, using this template -- Low Nail Company.xlsx - Limit the width of the workbook to 1 page using Portrait layout (to allow for printing and grading in Blackboard). Multiple pages "tall" are OK.- Label each question with titles and all answers with proper units (e.g. $, cases per order, $ per year, etc.). - Effective spreadsheet design must be used. For example, all input data must be shown in separate cells and all answers must be formulas that reference the input cells. In this way, any input can be quickly changed for immediate recalculation of your answers! This happens all the time on-the-job.

Unit 8 Project Find the next five terms of the arithmetic sequence 42, 37, 32, ... . Find the 24th term of an arithmetic sequence for which a1 = 2 and d = 6. Find the three arithmetic means between ­4 and 16. Find the sum of the arithmetic series for which a1 = 7, n = 31, and an = 127. Find the next three terms of the geometric sequence 81, 27, 9, ... . Find the eight term of the geometric sequence for which a1 = 5 and r = ­2. Find two geometric means between 7 and 189 Find the sum of the geometric series for which a1 = 125, r = 2⁄5, and n = 4. Find the sum of each series, if it exists. 15 9. ∑ (14 − 2k) k=3 10. 91 + 85 + 79 + ... + (­29) Find the first five terms of each sequence. a1 =2,an+1 =an +3 a1 =­4,an+1 =an +n2 Find the variance, mean, median, mode, and standard deviation for the given values. 13. 13, 15, 12, 10, 4, 16, 17, 22, 9 Use the data that shows the ages of the U.S. population to create a histogram. Tell whether the data is positively skewed, negatively skewed, or if it has a normal distribution. The number of home runs scored by teams in the Brooksfield baseball league are normally distributed and have a mean of 94 and a standard deviation of 8. What percentage of the teams have scored more than 102 home runs? Find the margin of error with the given conditions. Round to four decimal places. 16. p=33%andn=600. 17. 200 high school students were surveyed about whether they driving or taking the bus to school. 145 preferred driving.