代写LUBS1530 Business Analytics 1 Semester 2, 2024/2025代写C/C++程序

LUBS1530 Business Analytics 1

(Semester 2, 2024/2025)

Assessed Coursework

100% Assignment

Dataset: Boston Housing

Dataset comprises town-level socio-economic data on the housing in 506 towns comprising Greater Boston including data on pollution levels.

Variable definitions are included in the Excel workbook containing the dataset.

Objective

To understand the determinants of the median value of housing in 506 towns comprising Greater Boston.

Tasks

(All tasks must be undertaken using Excel. You will then use the results generated by your data analysis to complete the Answer Sheet included in this Assessment Brief. Only the completed Answer Sheet including the required screenshots is to be submitted.)

1. Calculate descriptive statistics for CRIME, ROOMS, AGE, TAX, PTRATIO and VALUE.

2. Generate histograms for CRIME, ROOMS, AGE, TAX, PTRATIO and VALUE.

3. Undertake skewness/outlier analysis and normality tests for CRIME, ROOMS, AGE, TAX, PTRATIO and VALUE.

4. Generate the correlation matrix for CRIME, ROOMS, AGE, TAX, PTRATIO and VALUE.

5. Create a scatterplot for VALUE vs ROOMS; include a linear trendline with the equation of the line and R².

6. Estimate a general regression model of VALUE using all the variables in the dataset.

7. Develop a specific regression model of VALUE that eliminates irrelevant variables and maximises R²(adj).

8. Undertake residual analysis for the estimated specific regression including residual plots and auxiliary regression analysis.

9. Complete the answer sheet and submit on Minerva (via TurnitIn).

This assignment is categorised RED for use of GenAI: you must not use any content generated by Artificial Intelligence (GenAI) in any part of this work.

https://generative-ai.leeds.ac.uk/ai-and-assessments/acknowledging-use-of-ai/

Assignments should be a maximum of 2000 words in length.

All coursework assignments that contribute to the assessment of a module are subject to a word limit, as specified in the assessment brief. The word limit is an extremely important aspect of good academic practice, and must be adhered to. Unless stated otherwise in the relevant module handbook (if one has been provided), the word count includes EVERYTHING (i.e. all text in the main body of the assignment including summaries, subtitles, contents pages, tables, supportive material whether in footnotes or in-text references) except the main title, reference list and/or bibliography and any appendices.  It is not acceptable to present matters of substance, which should be included in the main body of the text, in the appendices (“appendix abuse”). It is not acceptable to attempt to hide words in graphs and diagrams; only text which is strictly necessary should be included in graphs and diagrams.

You are required to adhere to the word limit specified and state an accurate word count on the cover page of your assignment brief. Your declared word count must be accurate, and should not mislead. Making a fraudulent statement concerning the work submitted for assessment could be considered academic malpractice and investigated as such. If the amount of work submitted is higher than that specified by the word limit or that declared on your word count, this may be reflected in the mark awarded and noted through individual feedback given to you.

The deadline date for this assignment is 12:00:00 noon on Wednesday 14^th May 2025.

An electronic copy of the assignment must be submitted to the Assignment Submission area within the module resource on the Blackboard MINERVA website no later than 12:00:00 noon prompt on the deadline date.

Faxed, emailed or hard copies of the assignment will not be accepted.

Failure to meet this initial deadline will result in a reduction of marks, details of which can be found at the following place:

https://students.business.leeds.ac.uk/assessment/code-of-practice-on-assessment/

SUBMISSION

Please ensure that you leave sufficient time to complete the online submission process, as upload times can vary. Accessing the submission link before the deadline does NOT constitute completion of submission. You MUST click the ‘CONFIRM’ button before 12:00:00 noon for your assignment to be classed as submitted on time, if not you will need to submit to the Late Area and your assignment will be marked as late. It is your responsibility to ensure you upload the correct file to the MINERVA, and that it has uploaded successfully.

It is important that any file submitted follows the conventions stated below:

MITIGATING CIRCUMSTANCES

If you are affected by circumstances that will have a short-term impact on your ability to complete coursework assessments (for example a minor illness), you can make an application for an extension to a coursework deadline. Please note, all extension requests must be made prior to the original assessment deadline. To read more about this process please click here - https://students.business.leeds.ac.uk/student-support/mitigating-circumstances-extensions-and-additional-consideration/

FILE NAME

The name of the file that you upload must be your student ID only.

ASSIGNMENT TITLE

During the submission process the system will ask you to enter the title of your submission. This should also be your student ID only.

FRONT COVER

The first page of your assignment should always be the Assessed Coursework Coversheet (individual), which is available to download from the following location:

https://students.business.leeds.ac.uk/forms-guidance-and-coversheets/

STUDENT NAME

You should NOT include your name anywhere on your assignment