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

Dbms., what is cascade rollback

what is cascade rollback

Instruction level-parallelism based on granularity size, Instruction level ...

Instruction level This is the initial level and the degree of parallelism is uppermost at this level. The fine grain size is used at statement or instruction level as only few

Signaling pvm process, Q. Signaling PVM process? int pvm_sendsig( ...

Q. Signaling PVM process? int pvm_sendsig( int tid, int signum ) Transmits a signal to other PVM process. tid is task identifier of PVM process to receive signal.

What are the important tools of a three-tier client server, What are the im...

What are the important tools of a three-tier client server? In a three-tier or multi-tier environment, there the client implements the presentation logic or the client. The bus

Need of the assembly language, Q. Need of the assembly language ? Machi...

Q. Need of the assembly language ? Machine language code comprises the 0-1 combinations which computer decodes directly.  Though the machine language has the following problems

What are the issues of software development, What are the issues of softwar...

What are the issues of software development One of main issues in software development today is quality. Software must be properly documented and implemented. The notion of sof

Multi-layer network architectures, Multi-Layer Network Architectures: ...

Multi-Layer Network Architectures: As we considered we saw in the previous lecture that perceptrons have limited scope in the type of concepts that they can learn - but they c

Explain about the view selection problem, Often calculating all the data is...

Often calculating all the data is not possible by aggregations for this reason some of the difficult data problems are solved. In order to verify which data should be solved and me

What is the difference between proc. sent by val and by ref, What is the di...

What is the difference between proc. sent BY VAL and By Ref? BY VAL: Alters will not be reflected back to the variable. By REF: Alters will be reflected back to that variab

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