Study Document
Microsoft Excel Data Analysis Chapter
Pages:3 (870 words)
Subject:Mathematics
Topic:Excel
Document Type:Data Analysis Chapter
Document:#33002641
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. 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 to Excel, and what steps you will take to ensure the data is usable for your purpose.
The easiest way to achieve this is to use the sort function to isolate the data points that you would like to rename. Then you can pick the first point, rename it, and then drag it to replace the rest of the data points. However, in a huge data set it may be more efficient to create a rule to automatically transfer the data.
* B - (TCO 2) Explain, based on material covered in this class, your approach to setting up your worksheet and organizing the data.
Because you have all sales records, you want to summarize it by month.
Again, you could use the data sort tool…
Related Documents
Study Document
Microsoft Office Is the Most Popular Comprehensive
Microsoft Office is the most popular comprehensive bundle of productivity applications in the world. It contains word publishing, spreadsheet, presentation, e-mail, and database software and is most often used with the Microsoft Windows operating system. It can also be used with the Apple Macintosh. The Microsoft Office suite enjoys almost universal worldwide familiarity. The most recent version of MS Office is Office XP, which is designed specifically to be compatible
Study Document
Microsoft Sustainability Microsoft's Sustainability Performance
Contributions to the Bill and Melinda Gates Foundation set up by Gates and his wife top $20 billion." (Hillis, 1) As indicated though, Microsoft's performance in the area of sustainability is not a simple black-out-white outlook. Quite to the contrary, its political activity seems almost counterintuitive to the actions the company has taken to improve its own achievement of sustainability. Namely, Schwartz reports the software giant to have fallen short
Study Document
Microsoft Office Has in the
This was specifically done to allow for greater data and information usability across all applications, a feature than had only been partially supported in the varying application versions in the past (Boeri, 2007). Microsoft apparently put a massive amount of effort into improving Excel, and the 2007 edition reflects much greater flexibility in graphing, table alignment, formatting and calculation options (Adams, 2006). There are also fewer constraints in Excel
Study Document
Microsoft's Strategies Relating to Leadership. First, an
Microsoft's strategies relating to leadership. First, an overview of the company will be provided, followed by a discussion of the company's leadership strategies. These strategies will be assessed as to their effectiveness, and compared to leading theories of effective management. An Overview of Microsoft Today, Microsoft is one of the world's largest businesses, and the world's largest and most influential software company (Wired News). The company's products have an extensive impact
Study Document
Microsoft Is a Company That Was Found
Microsoft is a company that was found to be in violation of antitrust laws by both the U.S. Justice Department and the European Commissions. The reason behind such a finding, is that Microsoft acted in a manner that was found to be overly aggressive in regards to its operating systems and software. As the Weil and McMillan article wrote that it was "alleged that Microsoft harmed Netscape's browser business through
Study Document
Microsoft Case Microsoft Career Development Case Study
Microsoft Case Microsoft Career Development Case Study The case presented in the brief concerning Microsoft provides an overview both of Microsoft's hiring and managerial advancement processes and of the career development path of a specific employee named Matt MacLellan. MacLellan is identified as a standout young rising star in a corporation built almost exclusively of young rising stars. The brief provides a narrative which traces MacLellan's evolution as a managerial figure under