(Steps Shown) Please complete the next problem using Excel and show all 5 steps of the hypothesis test. The data will be attached in an Excel Spreadsheet.
Question: Please complete the next problem using Excel and show all 5 steps of the hypothesis test. The data will be attached in an Excel Spreadsheet.
Using the attached data set, use the amounts of nicotine (mg per cigarette) in the king size cigarettes, the 100 mm menthol cigarettes, and the 100 mm non menthol cigarettes. The king size cigarettes are nonfiltered, non-menthol, and non-light. The 100 mm nonmenthol cigarettes are nonfiltered and non-light. Use a 0.05 significance level to test the claim that the three categories of cigarettes yield the same mean amount of nicotine. Given that only the king size cigarettes are nonfiltered, do the filters appear to make a difference?
Deliverable: Word Document 