Answered step by step
Verified Expert Solution
Link Copied!

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

image text in transcribed
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

blur-text-image

Get Instant Access with AI-Powered Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Students also viewed these Accounting questions