Your worksheet and organizing the data, Computer Engineering

Assignment Help:

You presently work for an automotive parts supply store. Your company is growing, and is considering expansion. The company presently has three locations (North, South, and Central) in one state, and wants to consider expanding within the similar state.  You have been presented with the sales figures for the last 3 years for each of your locations. Based on this information, you're tasked with analyzing present sales.
 
You have decided to investigate the trend in sales over the past 3 years. Respond fully to the following questions regarding this task:
 
A - The data for the North and Central locations has been given to you in the form of .csv files. The South location information is in an Excel file. Describe the steps involved in converting the information from the .csv files to Excel, and what steps you will take to assure the data is usable.

B - Describe, based on material covered in this class, your approach to setting up your worksheet and organizing the data.

C - Describe how you will visually represent the data for the sales of the individual stores and for the time period shown. You want to show the change in sales for every store over time for the past three years.

D - Once you have finished the above tasks, you plan to send the Excel workbook to your boss for evaluation. Your boss is not an Excel expert, and you are concerned that your formulas might accidentally be deleted or altered. Describe the methods you will use to assure


Related Discussions:- Your worksheet and organizing the data

Concept development of project, Concept Development Journal General In...

Concept Development Journal General Information: Once you have researched and gained some insight into the topic you must then begin developing your ideas and your conceptua

Design a model for object oriented development, Design a model for object o...

Design a model for object oriented development The model for object oriented development could be shown as in Figure. It could be classified as dynamic / static and physical /

Explain working neural network work, Q. Explain working neural network work...

Q. Explain working neural network work? ANSWER: A neural network has an input layer with the factors under consideration, a middle or hidden layer that assigns and adjusts weig

Qwerty - keyboard layout, Q. QWERTY - Keyboard Layout ? A keyboard layo...

Q. QWERTY - Keyboard Layout ? A keyboard layout is arrangement of keys across the keyboard. There is one keyboard layout which anybody who has worked on a standard keyboard or

What are the standard types of files produced, What are the standard types ...

What are the standard types of files produced? A PDF file is universally recognized by the internet and is also a secure image, given that an electronic footprint remains when

Write heterogeneous functions, Write "heterogeneous" functions If a pro...

Write "heterogeneous" functions If a program uses simulated, dynamically allocated multidimensional arrays, it becomes possible to write "heterogeneous" functions which don't h

Explain about aggregations, OLAP can process difficult queries and give the...

OLAP can process difficult queries and give the output in less than 0.1 seconds, for it to achieve like performance OLAP uses aggregations. Aggregations are built by aggregating an

Planning too much up front a mistake in an oosad, You can't plan only for t...

You can't plan only for the present phase of the project as your future activities are still coarse granular. To have good planning you require to have fine granularity w.r.t the t

State the relative addressing, State the Relative addressing The locati...

State the Relative addressing The location of data is specified relative to current value of the program counter. This is helpful for specifying location of data which is given

Write Your Message!

Captcha
Free Assignment Quote

Assured A++ Grade

Get guaranteed satisfaction & time on delivery in every assignment order you paid with us! We ensure premium quality solution document along with free turntin report!

All rights reserved! Copyrights ©2019-2020 ExpertsMind IT Educational Pvt Ltd