Question
i am in need of your help working on the following 1) Price Questions: a) At what price are the laptops actually selling? b) Does
i am in need of your help working on the following
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 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?.
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started