logo Use SA10RAM to get 10%* Discount.
Order Now logo

Ask This Question To Be Solved By Our ExpertsGet A+ Grade Solution Guaranteed

expert
Noormehal MohamaadFinance
(5/5)

829 Answers

Hire Me
expert
Sandeep TrivediEnglish
(5/5)

897 Answers

Hire Me
expert
Charlie BilyeuBusiness
(4/5)

773 Answers

Hire Me
expert
Aaron BiltoftStatistics
(5/5)

775 Answers

Hire Me
Excel
(5/5)

Firstly, you need to prepare the data for building the model. In classic data modeling tasks, you only use a portion of the data to train your model

INSTRUCTIONS TO CANDIDATES
ANSWER ALL QUESTIONS

Part 3

The marine biologists research team are satisfied with the excel application you have developed, which helped them greatly understand the abalone across the country. On top of the analysis, you have done in part 2, the scientists are keen to find some underlying patterns from the abalone data. In other words, the research team wants to build mathematical models for the abalone data, which reveal the fundamental relationships among the variables in the abalone data. As an expert in business analytics, you have the perfect skill set for this task.

To build a solid model, you need to go through the following steps and finalize your model in the end.

 

Task 1. Prepare the dataset

Firstly, you need to prepare the data for building the model. In classic data modeling tasks, you only use a portion of the data to train your model – this portion of the data is called the training set; the rest of the data are used to evaluate the performance of your model – this is called the test set.

What you need to do:

a. Create a new excel file called “Firstname_Lastname_DataModeling.xlsx”.

b. Name your current worksheet “Original Data”.

c. Copy the data in your “Personal Data” worksheet from your semester project part 2 and past the data set in the “Original Data” worksheet.

d. Create a new worksheet called “Training set” and copy the first 2/3 of the data from the “Original data” and paste them here.

e. Create a new worksheet called “Test set” and copy the rest of 1/3 of the data from the “Original data” and paste them here.

 

 

Task 2. Find relationships among variables in stacked data

Before modeling the data, you need to have a better understanding of the relationship among variables. The research team have specified a set of numerical variables that they care the most. They are listed in the table below. In particular, scientists are mostly interested in the rings of the abalone, since it tells the age of the abalone.

 

Length Diamete r Height Whole_weig ht Shucked_weig ht Viscera_weig ht Shell_weig ht Rings

 

What you need to do:

a. Create a new worksheet called “Stacked data analysis”

b. Use the “Training set”. Explore and create histograms for different variables listed above and then pick 3 most interesting histograms and describe the characteristics of each of them.

 

c. Use the “Training set”. Create a box plot for Shucked_weight, Viscera_weight and Shell_weight and describe characteristic for each of the variable in the plot.

d. Use the “Training set”. Explore and create scatter plots for different variables listed above, then pick 5 most interesting scatter plots and describe the characteristics of each of them.

e. Use the “Training set”. Calculate the correlation between every pair of the variables listed above. Identify the top-5-strong corelated variables. Apply conditional formatting on your computed results that indicates top-5-strong correlations.

f. Use scatter plots to demonstrate the strong corelated variables. Describe your findings.

(5/5)
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

Get Free Quote!

342 Experts Online