Laptop Sales at a London Computer Chain
Need help with this assignment?Get an original answer from a qualified tutor — from $10/page.
Get it written →3.3 Laptop Sales at a London Computer Chain: Bar Charts and Boxplots. The file LaptopSalesJanuary2008.xls contains data for all sales of laptops at a computer chain in London in January 2008. This is a subset of the full dataset that includes data for the entire year.
- Create a bar chart, showing the average retail price by store. Which store has the highest average? Which has the lowest?
- To better compare retail prices across stores, create side-by-side boxplots of retail price by store. Now compare the prices in the two stores from (a). Does there seem to be a difference between their price distributions?
NOTE:
- Please note XLMiner Explore is an interactive visualization tool for part b of 3.2 part b.
Your assignment results should be summarized in a report (Word document) which refer to the worksheets containing the charts in your final attached Spreadsheets.
Please note XLMiner Explore charts need to be screen shot to save.
Get a plagiarism-free answer to this question
Send us your instructions and we’ll match you with the best writer in your subject.
- 100% human-written, zero AI
- Turnitin report included
- Confidential — we never share your data
- Free revisions & refunds