https://www.mediafire.com/file/r296l10wi14841l/London+Postcodes+(1).txt/file

https://www.mediafire.com/file/3wwsrydvcbtcfn5/Laptops+(1).txt/file

https://www.mediafire.com/file/r025o5c8tv97vp5/PC+Universe+-++2008+Point+of+Sale+Data+(1).txt/file

PLEASE DOWNLOAD THE FILES FROM THE ABOVE LINKS

Laptop Sales at a London Computer Chain: Interactive Visualization.The filePC Universe - 2008 Point of Sale Data.txtis a comma-separated file with nearly 300,000 rows. ENBIS (the European Network for Business and Industrial Statistics) provided these data as part of a contest organized in the fall of 2009. In addition, the fileLaptops.txtcontains details about the 864 laptop configurations that they sell. There is also a file containing the X and Y coordinates for London postcodes inLondon Postcodes.txt.

Scenario:Imagine that you are a new analyst for a company called Acell (a company selling laptops). You have been provided with data about products and sales. You need to help the company with their business goal of planning a product strategy and pricing policies that will maximize Acell's projected revenues in 2009. Open the data in JMP. Check to ensure that the data and modeling types in the data table are correct for each of the variables and answer the following questions.

Use JMP for this assignment.

DATA DICTIONARY

PC Universe - 2008 Point of Sale Data.txt

Date: Date and time of Sale - Continuous/Date

Configuration: ID number - Nominal

Customer Postcode: London postcode for customer - Nominal

Store Postcode: London postcode for Retail store location - Nominal

Retail Price: Price in Pounds - Continuous

Laptops.txt

Configuration: ID number - Nominal

Screen Size: Size of screen in inches - Continuous

Battery Life: Life of battery in hours - Continuous

RAM: Computer RAM in GB - Continuous (or should that be nominal or ordinaljQuery224023941999975965755_1617857301805? Only 4 values??)

Processor Speeds- processor speed in GHz - Continuous (or should that be nominal or ordinal??? Only 4 values??)

Integrated Wireless- Yes/No if wireless - Nominal

HD Size- Size of Hard Drive in GB - Continuous

Bundled Applications- Yes/No if has applications - Nominal

London Postcodes.txt

Postcode: London Postcode - Nominal

OS X: X coordinate for postcode - Continuous

OS Y: Y coordinate for postcode - Continuous

Create graphs to help you answer these questions. Save the graphs to your Data Table (or save the code if you are using other software like R or Python or save a Tableau Extracted Workbook).

Clearly label each question.

For each,

• Put screenshots of your graphs
• Answer the question

1)Price Questions:

a) At what price are the laptops actually selling?

b) Does price change with time? (Hint: Make sure that the date column is recognized as such. JMP will then allow dynamic transformations and allow you to plot the data by weekly or monthly aggregates, or even by day of week. So create more "Date" columns in the graph builder by right clicking the date, and choosing "Date Time" so you can look at the Date with different aggregates such as Month, Day or Week, etc.)

c) Are prices consistent over retail outlets?

d) How do the sales volume in each store relate to Acell's revenues (based on prices)?

2)Location Questions:

a) Which stores are selling the most?

b) Where are the stores and customers located? Join the Customer and Store OS X and OS Y values Hint: This was in the in-class assignment so check the end of the posted walk-thru if you need help.

c) How far would customers travel to buy a laptop?

i)Hint 1:Use the coordinated highlighting between multiple visualizations in the same page, for example, select a store in one view to see the matching customers in another visualization.

ii)Hint 2:Explore the use of filters to see differences. Be sure to filter in the zoomed-out view. For example, try to use "store location" as an alternative way to dynamically compare store locations. This might be more useful to spot outlier patterns if there were 50 store locations to compare.

d) Try an alternative way of looking at how far customers traveled by creating a distribution graph showing this distance. A new column should be created that computes the distance between customer and store. (For information on creating formulas in JMP, search for "Creating Formulas" in the JMP documentation or seejmp.com/learn.). Use the Euclidean distance formula: where 1 is the customer location and 2 is the store location. For reference, my formula in JMP looks like this: To interpret this distance I looked at a few rows in the table and found the "crow flies" distance in miles between the zip codes and determined that an approximate calculation is Distance / 1604 to convert to miles. So the first row shows two zip codes that are approximately 1.5 miles apart (2405.9/1604) = 1.49.

3)Configuration Questions:

a) What are the details of each configuration? How does this relate to price? Hint: You will need to use a Table Join with the Laptops.txt file similar to how you joined in the post code data.

b) Do the stores sell all configurations?.