Skip to main content
Data Analysis Chapter Undergraduate 851 words

Analyzing home improvement store sales data with Excel

~5 min read
✍️ How to write this paper — writing tools ▾
Essay 851 words

Excel Q's

(TCOs 2, 3, 7 and 9) You currently work for a home improvement store.

Your company is growing and is considering expansion. The company currently has three locations (East, West, and Central) in one state and wants to consider expanding within the same state. You have been presented with the sales figures for the last three years for each of your locations. Based on this information, you are tasked with analyzing current sales.

The company classifies the sales at the stores into two categories. They are either retail sales to home users, or wholesale to contractors. You want to determine whether the growth is in the retail sales, the wholesale sales, or equally in both to better develop an expansion strategy.

The data from these operations should be combined in the easiest way possible. If the data sample is small it might be easiest to just cut and paste the data into one file. However, if the three locations have a large data set then the "import" data feature can be used to integrate the data. Once the data is combined into one file then the sort feature can be used to isolate the various items of interest. Once the categories are developed then functions such as autosum can be used to total up the different categories of interest.

* A - (TCO 9) The data has been provided to you in one combined .csv file showing the sales for all three stores for the last three years. The stores all categorize sales as either retail or wholesale, but they are not consistent in how they do this. The West location uses a code of R. For retail, or W. For wholesale.

573 Words Hidden
The other locations use RS for retail sales or WS for wholesale sales. Explain the steps involved in converting the information from the .csv file…
Cite This Paper
PaperDue. (2011). Analyzing home improvement store sales data with Excel. PaperDue. https://www.paperdue.com/essay/microsoft-excel-115822

Always verify citation format against your institution’s current style guide requirements.