Six toilet paper samples were subjected to a quality test. The...
50.1K
Verified Solution
Link Copied!
Question
Accounting
Six toilet paper samples were subjected to a quality test. The partly completed quality report form is below. Quality ratings range from 1-100, where 100 is the best quality rating. The numbers may change each day, so your formulas should work regardless of the numbers in the cells. Grade B Quality 46 32 85 63 1 Toilet paper sample number 2 1 3 2 4 3 5 4 6 5 7 6 8 9 Mean quality rating 10 Range of quality ratings 11 Number of samples with grade "High" 74 89 A Write the formula for cell B9: B. Write the formula for cell B10, indicating the range (difference) between the highest and lowest values for the ratings: Quality ratings are converted to toilet paper grades Toilet paper with quality rating of 70 or higher are classified as "High" grade, toilet paper with quality ratings of 40-69 are classified as "Mid" grade, and toilet paper with quality ratings lower than 40 are classified as "Low" grade. C. Using an IF statement, write the formula for cell C2 in a manner that can be copied and pasted into cells C3.07 D. Write the formula for cell B11
Answer & Explanation
Solved by verified expert
Get Answers to Unlimited Questions
Join us to gain access to millions of questions and expert answers. Enjoy exclusive benefits tailored just for you!
Membership Benefits:
Unlimited Question Access with detailed Answers
Zin AI - 3 Million Words
10 Dall-E 3 Images
20 Plot Generations
Conversation with Dialogue Memory
No Ads, Ever!
Access to Our Best AI Platform: Flex AI - Your personal assistant for all your inquiries!
