Q

Business Analytics Coding Assignment Help

Business Analytics Coding Assignment Help - Get The Business Analytics Coding Assignment Help Service Today From UK Qualified Tutors And Score Top Grades!!
Previous << >> Next

ARE YOU LOOKING FOR RELIABLE BUSINESS ANALYTICS CODING ASSIGNMENT HELP SERVICES? MIRACLESKILLS.COM IS RIGHT CHOICE AS YOUR STUDY PARTNER!

Business Analytics Coding Assignment -

Section A - Tasks 1-5 focus on housing data from the 1990 California census, with each row representing a census block group, which is the smallest geographical unit for which sample data is provided by the U.S. Census Bureau. A census block group usually has a population of about 600 to 3,000 people. The data is sourced from Kaggle1 and is provided in the housing.csv file on iLearn. It consists of the following fields:

i. longitude - a measure of how far west a house is; a higher value is farther west.

ii. latitude - a measure of how far north a house is; a higher value is farther north.

iii. housing_median_age - median age of a house within a block in years; a lower number is a newer building.

iv. total_rooms - total number of rooms within a block.

v. total_bedrooms - total number of bedrooms within a block.

vi. population - total number of people residing within a block.

vii. households - total number of households, a group of people residing within a home unit, for a block.

viii. median_income - median income for households within a block of houses (measured in tens of thousands of US Dollars).

ix. median_house_value - median house value for households within a block (measured in US Dollars).

x. ocean_proximity - location of the block with respect to the ocean.

Task 1 -

1. Display the structure of the housing data and calculate descriptive statistics for the numerical columns (mean, median, standard deviation, maximum and minimum).

2. How many rows and columns are in this dataset?

3. Create a frequency table showing the unique values of the ocean proximity variable and the number of times these values occur in the dataset.

4. Create a pie chart showing the breakdown of the categories in the ocean proximity variable. Display the percentage of each category on the pie chart. Interpret the plot.

SAVE YOUR HIGHER GRADE WITH ACQUIRING BUSINESS ANALYTICS CODING ASSIGNMENT HELP & QUALITY ASSESSMENT WRITING SERVICES OF MIRACLESKILLS.COM

Task 2 -

1. How many values are missing from the total bedrooms variable? Print out the first 5 rows in the housing data with missing values for this variable.

2. Create a violin plot showing how the distribution of median house value differs across the location of the block with respect to the ocean. Interpret the plot.

Task 3 -

1. Add a new column (age_category) to the housing data that classifies each block into one of five categories depending upon the median age of a house:

i. 0-10 years - Cat 1

ii.10-20 years - Cat 2

iii. 20-30 years - Cat 3

iv. 30-40 years - Cat 4

v. > 40 years - Cat 5

2. Print out the median age of a house and the age category for the first 10 rows in the dataset.

3. Create a grouped bar chart showing the breakdown of the age_category variable for each  category in the ocean proximity variable (i.e. put ocean proximity on the x-axis and age_category in the bars). Interpret the plot.

Task 4 -

1. Investigate the relationship between total bedrooms (x-axis) and median house value (yaxis) by creating a scatter plot with a linear regression line through it and a joint plot. Comment on what the plots say about this relationship.

2. Filter the housing data so it only contains census blocks with a median income above $60,000 USD and a median house age less than 5 years. Print the first 5 rows of this filtered dataset. How many census blocks are in this filtered dataset?

3. Randomly sample 500 rows from the housing dataset and store them in a variable. Print out the first 10 rows of this dataset.

4. Create a scatter plot showing the relationship between total rooms (x-axis) and median house value (y-axis) for the randomly sampled data, colouring points on the chart based on a census block's median income. Interpret the plot.

DO YOU WANT TO EXCEL IN BUSINESS ANALYTICS CODING ASSIGNMENT? HIRE TRUSTED TUTORS FROM MIRACLESKILLS AND ACHIEVE SUCCESS!

Task 5 -

1. Calculate the number of people per household for each census block. Print out the top ten census blocks with the largest number of people per household. What do you notice?

2. Plot a histogram of the number of people per household and display its mean and median as straight and dashed lines respectively on the plot. Include the actual values of the mean and median in the legend.

3. Create the same histogram, but this time only include census blocks with less than 10 people per household. Which plot do you prefer and why?

4. Compare the data of the ten census blocks over the entire housing dataset with the lowest median income with the data of ten census blocks with the highest median income.

MIRACLESKILLS.COM ACCEPTS INSTANT AND SHORT DEADLINES ORDER FOR BUSINESS ANALYTICS CODING ASSIGNMENT - ORDER TODAY FOR EXCELLENCE!

Section B - This part of the assignment involves repeatedly simulating an automated (not interactive) game of Snakes and Ladders and calculating the probability of winning the game. Simulations are a common way to assess the probability of an event happening in real life. In this game, players start at step 1 and win if they get past step 100 within 30 moves. There are no snakes or ladders for the first ten steps. After this, each step has a 15% chance of being a ladder and a 20% chance of being a snake. Ladders take players forward a random number of steps between 1 and 10 and snakes take players back a random number of steps between 1 and 10. The steps which are ladders/snakes, along with their number of steps forward/back, should be predetermined before the start of a game. For each move, players roll a random dice and move forward the number of steps on the dice (i.e. 1-6 steps). If a player lands on a ladder/snake, they go forward/back the appropriate number of steps before their next move.

1. Simulate the Snakes and Ladders game described above 1000 times. At the start of each game, the board should be reset (i.e. steps which are ladders/snakes should be recalculated).

2. The results of each game should be recorded in a dictionary with two keys, Won and Lost, which store the number of games won and lost respectively (i.e. when a game is won, add one to the value of the Won key). Print out this dictionary after the 1000 simulations.

3. Report the probability of winning based on the 1000 simulations.

NEVER LOSE YOUR CHANCE TO EXCEL IN BUSINESS ANALYTICS CODING ASSIGNMENT - HIRE BEST QUALITY TUTOR FOR ASSIGNMENT HELP!

Section C - A trader is developing a new trading strategy to apply on the stock market. He has collected stock price data to backtest his strategy (see how it performs on historical data to get an idea of how it will perform in real life). His strategy involves buying whenever the 5-period moving average of a stock's daily closing price crosses its 20-period moving average and selling when it crosses back over. The strategy buys and sells on the opening price of the day after a buy/sell signal (i.e. if the 5-period moving average crosses the 20-period moving average on 01/01/2018, it will buy/sell on the opening price of the 02/01/2018). The trader has asked for your help in evaluating the strategy on the stock data on iLearn. This data consists of the daily stock prices for ANZ, CBA, BHP, RIO and WES from January 2002 to August 2018. Data for each stock is provided in a separate CSV file. Each file contains the following fields:

i. Date - date of the trading day

ii. Open - opening price of stock that day

iii. High - highest price of stock that day

iv. Low - lowest price of stock that day

v. Close - closing price of stock that day

vi. Volume - amount of stock that was traded that day

vii. Member - whether the stock is a member of ASX200

Task 1 -

1. Create a line plot using different colours to show the closing prices of the stock data over time.

2. Calculate and display the correlations between the closing prices of the stock data. Create a heatmap showing these correlations. Comment on what the numbers and plot say about the correlation between the stocks.

ORDER NEW BUSINESS ANALYTICS CODING ASSIGNMENT & GET 100% ORIGINAL SOLUTION AND QUALITY WRITTEN CONTENTS IN WELL FORMATS AND PROPER REFERENCING.

Task 2 -

1. Calculate 5-period and 20-period moving averages for each stock. Print the last 5 values of each moving average for each stock.

2. Create a separate line plot for each stock from 2008 - 2010, with the stock's opening price, 5-period moving average and 20-period moving average displayed using different colours.

3. Record the buy and sell transactions for each stock based on the strategy above and print out the buying/selling dates/prices for the first 10 transactions of each stock. Here's some additional information that might be helpful:

i. There are no equity constraints (i.e. the trader is able to make a trade every time the strategy conditions are met, regardless of how much money he has gained/lost previously and how many other stocks he is currently holding).

ii. If a trade is open when the data for a stock ends, it should be closed (i.e. stocks sold) on the last day that data is available for. For example, if a trade is open for BHP on 10/08/2018 (last day of data) it should be closed at the open price on that day.

iii. There are no transaction costs.

iv. 1000 stocks are purchased at a time.

Task 3 -

1. Create a data frame containing information about all of the trades the strategy made (i.e. trades for every stock should be in the one data frame). For this task, a trade is a pair of buy and sell transactions. For example, if I buy 1000 shares in Westpac and then sell them three days later, I have made one trade, which is comprised of two transactions (buying the shares and then selling them). Print the first 10 rows and last 10 rows of the data frame. The data frame should have the following columns:

i. Stock - name of the stock

ii. Open_Date - starting date of the trade

iii. Close_Date - closing date of the trade

iv. Open_Price - buying price of the trade

v. Close_Price - selling price of the trade

vi. Quantity - trade quantity (hint - this should always be 1000 - see Task 2)

vii. Profit - profit of the trade

2. Calculate descriptive statistics (sum/total, number of trades, mean, median, standard deviation, maximum and minimum) of the trading profits for each stock, as well as the total trading profits.

3. Comment on the performance of the strategy, including which stock performed the best and whether you would recommend this strategy to the trader.

GET GUARANTEED SATISFACTION OR MONEY BACK UNDER BUSINESS ANALYTICS CODING ASSIGNMENT HELP SERVICES OF MIRACLESKILLS.COM - ORDER TODAY NEW COPY OF THIS ASSIGNMENT!


Want to Excel in Course? Hire Trusted Writers for Help! —> https://miracleskills.com/

Lists of comments


Leave a comment


Captcha