Paper On Data Analysis Assignment | Homework Help Websites

Review all the analyses performed for this lab activity, and write a one-page opinion paper summarizing at least two key findings that you believe are significant for Adventure Works Cycles, and making at least two recommendations for actions that management should take in response.professional writing services near me Your paper should be in APA format, professionally written, and should be free of grammatical errors, typos, and misspellings. Save your paper in a Microsoft Word file named Lab1_yourlastname_Paper.docx.

Save Time On Research and Writing
Hire a Pro to Write You a 100% Plagiarism-Free Paper.
Get My Paper

I already did this part on excel:

Step 1: Importing, Cleaning, and Converting Data

Adventure Works has supplied you with sales data extracted from their corporate database in the form of a text file. In this section, you will import, clean, and convert the data to prepare it for analysis.

  1. Download and save the file AdventureWorksOrders.txt (Links to an external site.)Links to an external site.. Be sure to save the file rather than opening it directly from this link (it will not open in Excel because it is a text file). If you are not given the option of saving the file when you click on the link, right-click it and select “Save link as” or “Save target as.”
  2. For this lab, you may use your own copy of Microsoft Excel 2016, or you may use Excel 2016 in the Citrix virtual lab environment. You are recommended to use the virtual lab to become familiar with it, as it will be required for some future labs. You should definitely use the virtual lab if your own copy of Excel is not the 2016 version, or if you are not using the Microsoft Windows operating system (the version of Excel for the Mac OS is significantly different from the version for Windows).

    If you will be using the virtual lab environment, log into it as directed in the Lab Resources section above and copy the AdventureWorksOrders.txt file to your virtual home drive (the F: drive in the virtual environment, labeled with your DSI number). See the Lab Resources section on the Introduction & Resources area under Modules > Course Resources page for tutorials on accessing the Citrix virtual lab environment, installing the required Citrix receiver software, finding and launching applications, and copying files to and from your virtual home drive.

  3.  Launch Excel 2016 and create a new blank workbook.
  4.  Using the Get External Data From Text command on the Data tab of the ribbon, import the data from the AdventureWorksOrders.txt file into Excel. The file is a delimited file in comma separated value (CSV) format.
  5. Rename the worksheet containing the imported data to sales data.
  6. Format the worksheet professionally, making sure that column headings are bolded; all dollar values are formatted as currency; and column widths are set appropriately.
  7. Clean the data by spell-checking all appropriate columns and deleting any rows containing missing observations, outliers, or duplicate entries.
  8. Add a column titled OrderTotal that uses a formula to calculate the total price for each order, based on the UnitPrice and OrderQty columns.
  9. Add a column titled FullName that contains the customer’s full name by concatenating the FirstName and LastName columns.
  10. Add a column titled OrderCategory that categorizes orders as large, medium, or small based on the OrderTotal, with large orders having OrderTotal greater than $1,500; medium orders having an OrderTotal between $500 and $1,500; and small orders having an OrderTotal less than $500.
  11. Save the workbook using the file name Lab1_yourlastname.xlsx. If you are using the virtual lab environment, you should save it to a folder on your virtual home drive.

NOTE: Save your work before continuing on to Step 2!

Save Time On Research and Writing
Hire a Pro to Write You a 100% Plagiarism-Free Paper.
Get My Paper
Calculate the price
Make an order in advance and get the best price
Pages (550 words)
*Price with a welcome 15% discount applied.
Pro tip: If you want to save more money and pay the lowest price, you need to set a more extended deadline.
We know how difficult it is to be a student these days. That's why our prices are one of the most affordable on the market, and there are no hidden fees.

Instead, we offer bonuses, discounts, and free services to make your experience outstanding.
How it works
Receive a 100% original paper that will pass Turnitin from a top essay writing service
step 1
Upload your instructions
Fill out the order form and provide paper details. You can even attach screenshots or add additional instructions later. If something is not clear or missing, the writer will contact you for clarification.
Pro service tips
How to get the most out of your experience with Homework Writing Services
One writer throughout the entire course
If you like the writer, you can hire them again. Just copy & paste their ID on the order form ("Preferred Writer's ID" field). This way, your vocabulary will be uniform, and the writer will be aware of your needs.
The same paper from different writers
You can order essay or any other work from two different writers to choose the best one or give another version to a friend. This can be done through the add-on "Same paper from another writer."
Copy of sources used by the writer
Our college essay writers work with ScienceDirect and other databases. They can send you articles or materials used in PDF or through screenshots. Just tick the "Copy of sources" field on the order form.
See why 20k+ students have chosen us as their sole writing assistance provider
Check out the latest reviews and opinions submitted by real customers worldwide and make an informed decision.
The paper was beautifully written and the ppt slide exceeded my expectations. Thank you so much for assisting me with a last minute assignment.
Customer 452455, May 9th, 2023
A few mistakes but overall an excellent paper
Customer 453915, September 13th, 2022
Excellent job
Customer 456821, May 3rd, 2022
Art (Fine arts, Performing arts)
Always follow instructions, especially on style.
Customer 460547, March 29th, 2022
I received my paper early and it is very well written. Thank you!!
Customer 462821, April 6th, 2022
Marketing & Advertising
Excellent work. Looking forward to your future contributions.
Customer 463467, December 1st, 2022
Excellent work
Customer 456821, March 28th, 2022
Business and administrative studies
This was done very well. Thank you!
Customer 458435, September 10th, 2022
Good job.
Customer 462783, March 31st, 2022
Health Care
It is exactly my expectation. Thank you.
Customer 454755, June 30th, 2020
Smart response.
Customer 462457, April 13th, 2022
Construction Management
Customer 463153, July 14th, 2022
Customer reviews in total
Current satisfaction rate
3 pages
Average paper length
Customers referred by a friend
15% OFF your first order
Use a coupon FIRST15 and enjoy expert help with any task at the most affordable price.
Claim my 15% OFF Order in Chat