Answered step by step
Verified Expert Solution
Question
1 Approved Answer
QUESTION 8 Ace Hardware Store collected data on the sales volume for five locations for the past four months. The data are input into an
QUESTION 8
- Ace Hardware Store collected data on the sales volume for five locations for the past four months. The data are input into an Excel spreadsheet where columns A through E represents the location names and column F represents the sales for each day for the past four months at that location. In order to construct a scatter diagram that displays the percent of total sales by location for each day for the past six months, the required steps in Excel will be to:
- 1)Determine the total sales by location.
- 2)Input the daily sales for each location
- 3)Divide the daily sales for a particular location by the total sales for that location.
- What would be the correct order of these steps?
- 1. 2. 3.
- 2. 1. 3.
- 2. 3. 1.
- 1. 3. 2.
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