Question
Solve the Questions below : 1 a) Which stores are selling the most? b) Where are the stores and customers located? Join the Customer and
Solve the Questions below :
1
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 see jmp.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?.
![image text in transcribed](https://s3.amazonaws.com/si.experts.images/answers/2024/06/66790bf0c5173_94466790bf0afe92.jpg)
![image text in transcribed](https://s3.amazonaws.com/si.experts.images/answers/2024/06/66790bf12e58e_94566790bf11844f.jpg)
![image text in transcribed](https://s3.amazonaws.com/si.experts.images/answers/2024/06/66790bf19d482_94566790bf18454d.jpg)
![image text in transcribed](https://s3.amazonaws.com/si.experts.images/answers/2024/06/66790bf21d4f7_94566790bf1f3a8b.jpg)
Step by Step Solution
There are 3 Steps involved in it
Step: 1
![blur-text-image](https://dsd5zvtm8ll6.cloudfront.net/includes/images/document_product_info/blur-text-image.webp)
Get Instant Access with AI-Powered Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
![blur-text-image](https://dsd5zvtm8ll6.cloudfront.net/includes/images/document_product_info/blur-subtext-image.webp)
Step: 3
![blur-text-image](https://dsd5zvtm8ll6.cloudfront.net/includes/images/document_product_info/blur-subtext-image.webp)
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started