Answered step by step
Verified Expert Solution
Question
1 Approved Answer
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
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
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access with AI-Powered Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started