Answered step by step
Verified Expert Solution
Question
1 Approved Answer
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 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
Step: 1
Get Instant Access to Expert-Tailored 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