Question 2 (20 marks) Clean the ABS data setDownload ABS data set. Fill the table in the template for question 2. Then explain the data cleaning process in less than 150 words. Include the following issues in your explanations. Categorical and numerical variables. The number of missing values. Outliers associated with every variable. Identify how many observations you have after cleaning the data.

Question 3 (40 marks) Based on the clean data set from question 2, Use descriptive analytics techniques to identify the relation of all the variables with the variable absenteeism time in hours. Excluding the variable absenteeism time in hours, there are twenty variables in the data set. Therefore, you should develop twenty figure and/ or tables to identify the relationship between every variable and the variable absenteeism time in hours. Based on developed figures and/ or tables choose six most relevant variables. Include the visuals (figures/ tables) associated with the six most relevant variables in the answer sheet. Interpret them in less than 150 words. (10 marks) Develop a regression model with absenteeism time in hours as the output variable and the six variables identified in part 3.A as the input variables. Present the regression table and the regression equation. Comment on the regression table and regression equation. Word limit is 150 words. (10 marks) Try to increase the accuracy of the model in several iterations. Use different techniques to increase the model accuracy as you judge them suitable, for example, you can include or exclude different variables, or you can combine different levels of a categorical variable. Present a final regression equation and a final regression table. Interpret the final regression table and equation. Explain how you increased the accuracy of the model. Please use less than 300 words for this section. (20 marks) Note: the accuracy of the model can be low.

Question 4 (10 marks) Based on the clean data set from question 2, create a new column and name it high_absenteeism. If the absenteeism in hours is more than 8, high_absenteeism is equal to 1 otherwise it is equal to 0. Choose the six most relevant numerical variables as independent variables to develop a logistic regression model with high_absenteeism as the dependent variable. Partition the data as 70 % and 30 % for the training and the test set, respectively. Present the logistic regression equation for the training and the test set. Comment on the logistic regression equations. Explain the procedure for selecting the most relevant variables. Please use less than 150. words for this section. Note: for using the app you should save the file as CSV. Note: try to delete all the irrelevant variables from the dataset and only include the six independent variables and one dependent variable. Otherwise, you increase the chance crashing the app.

Question 5 (20 marks) Assume that you are a business analyst in a manufacturing company.

Your manager gave you a task to optimise the scheduling of a project. Your job is to minimise the overall manufacturing time of a project. There are four items to be manufactured and four different types of machinery are available for the manufacturing task. Due to operational reasons, every machinery can only be allocated to the manufacturing of one item. Every item can only be manufactured by one machine. Different machinery has different speeds in manufacturing different items. Let us say i and m represent item and machinery, respectively. represents the first item, represents the second item and so on. represents the first machine, represents the second machine and so on. The duration of manufacturing every item pertaining to every machinery is presented in the below table. In this problem the sequence of manufacturing is important. Items , and should be manufactured before manufacturing item . Capture.JPG Write the linear optimisation model for the company to make the best decision. (10 marks) Solve the model, present the results, and interpret them. Use less than 150 words. (10 marks) Hint: you can use a binary variable such as which can take values of zero and one. Let us say if machine is engaged to manufacture item otherwise.

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

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

7COM1028 Secure Systems Programming Referral Coursework: Secure

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

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!

263 Experts Online