Question: The Data in Range L1:P175 1 The month data in L is in General Format Switch it to Date Format 2 Using Data Analysis

The Data in Range L1:P175 1 The month data in L is

The Data in Range L1:P175 1 The month data in L is in "General" Format Switch it to "Date" Format 2 Using Data Analysis Toolpak, run the descriptive statistics for "Fortified", "Red", "Rose" and "Sparking" Comment on what you have observed on the data 3 What is the rank of 1318 in Red (in ascending order)? What is the rank of 99 in Rose (in decending order)? 4 If the target of sales is 500, what percentages of "Red" sales meet this target? If the target of sales is 1500, what percentages of "Sparkling" sales NOT meet the target? 5 20% of "Fortified" sales have a sales exceeding what value? 40% of "Sparkling" sales have a sales smaller than what value?

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Accounting Questions!