Create a new column called LogDur whose value is equal to the log of the Duration field Examine the distribution of the Duration field and provide a summary

INSTRUCTIONS TO CANDIDATES

ANSWER ALL QUESTIONS

Instructions 

• Perform all analysis in JMP.  

• Organize your results into a single MS Word file, by exporting output from JMP. 

• Please let us know if you have any other questions about the content.   

1) New Variables/Variable Transformation (Datafile  CallLengths.xlsx) – 30 points

Import the spreadsheet into JMP (this may require you to first open in Excel and then Save As CSV).  

a. Examine the distribution of the Duration field and provide a summary (histogram, descriptive statistics, missing value count, number of outliers, etc.).

NOTE:  For (b) and (c) below, exclude all records with missing values or extreme outliers.  

b. Create a new column called LogDur whose value is equal to the log of the Duration field.  Examine the distribution of the Duration field, and provide a summary (histogram, descriptive statistics, missing value count, number of outliers, etc.).  

c. Comment briefly on the how the shape of the distribution of the LogDur field as compared to the shape of the distribution of the Duration field.  

2) Correlations (Datafile:  BodyMeasurements.jmp) – 20 points

This data corresponds to body measurements for a group of randomly selected men. 

a. Calculate the correlations between all of the variables in this dataset and the scatterplots of all of the pairs of these variables  

b. Comment on the nature of these relationships. 

3) Data Visualization and Initial Analysis (Datafile:  Laptop Sales.xlsx) – 50 points

To:  Your Team 

From: Rosie Accell, CEO

Accell Computers

Cc:  MBA 6520 Teaching Team 

Subject: What Happened Last Year!? 

I just got done listening to a horrible(!) presentation by some damn quant consultants.  They were supposed to help us use the data that we had provided them about last year’s sales to provide some insights about things we should be aware of and act on for the coming year.  Instead, they just threw up a bunch of slides with random charts and statistics. I couldn’t figure out what they had done or why they were telling me about it.

Look, I’m confident that there is a lot of valuable information in that dataset, and I’m counting on this team to help me unlock it. With that JMP software I’ve heard so much about – and with all that stuff you learned in your MBA program! – I’m confident that you can dig into the data and bring back some insights that can help me explain (a) what happened last year and (b) what you think it means for our business going forward.  

I wish I could provide you with some more guidance but I don’t have time.  Big picture is that I’m interested in knowing about my customers and also about my stores.  You’ve got almost 300,000 records – one for every single laptop bought at every one of our stores last year – so just roll up your sleeves and dig in.  

I need to see what you have in about a week. Don’t worry about putting together a bunch of super slick slides for this project.  Just find the insights that you think are valuable and use some pictures to explain them to me. 

Go to it.  I’m counting on you. 

You have a great deal of freedom in the analysis that you do for this problem.  However, your results are required to include the following:

• A detailed description of at least one numerical variable (histogram, descriptive statistics, missing value count, number of outliers, along with your own commentary about what is notable)

• A detailed description of at least one categorical variable (histogram, descriptive statistics, missing value count, number of outliers, etc., along with your own commentary about what is notable)

• A breakdown of retail price across different values for some categories (months, days of week, variables relating to geography, features, etc.) along with your insights about what you observe. 

Attachments:

Related Questions

. The fundamental operations of create, read, update, and delete (CRUD) in either Python or Java

CS 340 Milestone One Guidelines and Rubric  Overview: For this assignment, you will implement the fundamental operations of create, read, update,

. Develop a program to emulate a purchase transaction at a retail store. This  program will have two classes, a LineItem class and a Transaction class

Retail Transaction Programming Project  Project Requirements:  Develop a program to emulate a purchase transaction at a retail store. This

. The following program contains five errors. Identify the errors and fix them

7COM1028   Secure Systems Programming   Referral Coursework: Secure

. Accepts the following from a user: Item Name Item Quantity Item Price Allows the user to create a file to store the sales receipt contents

Create a GUI program that:Accepts the following from a user:Item NameItem QuantityItem PriceAllows the user to create a file to store the sales receip

. The final project will encompass developing a web service using a software stack and implementing an industry-standard interface. Regardless of whether you choose to pursue application development goals as a pure developer or as a software engineer

CS 340 Final Project Guidelines and Rubric  Overview The final project will encompass developing a web service using a software stack and impleme