Answered step by step
Verified Expert Solution
Link Copied!

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

image

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

blur-text-image

Get Instant Access to Expert-Tailored 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

Recommended Textbook for

Intermediate Accounting

Authors: kieso, weygandt and warfield.

14th Edition

9780470587232, 470587288, 470587237, 978-0470587287

More Books

Students also viewed these Accounting questions

Question

Outline Watson and Rayners classic work on fear conditioning.

Answered: 1 week ago