代写Applied Statistics 161.111 S1 2024 Assignment 1代做Java程序

Applied Statistics 161.111 S1 2024

Assignment 1

Due date: 11PM Thursday 18^th April 2024 (NZT)

Total marks: 30

Assessment value: 17%

Background

The population of interest is round cut diamonds for sale in New Zealand.

Data was collected from a random sample of 229 round cut diamonds from a single New Zealand based retailer of diamond jewellery.

The data consists of the price of the diamond (in $NZ), the colour grade (a six point scale from D to I, D being colourless to I being nearly colourless) and the Lab which did the certification of the colour grade (Lab A or B). The data is in the Excel file Diamonds_2024_S1.xlsx

Use the data to answer the following questions in the spaces provided.

Use Excel and incorporate the output into your answers. You can re-size the answer spaces.

When you are finished your assignment, save it as a pdf and upload to Stream Assignment 1 Dropbox

Part A: Exploratory analysis of Colour [6 marks]

A1: Use Excel to produce a table of counts showing the number of diamonds in each colour grade. [2 marks]

A2: Use Excel to draw an appropriate graph to display the table you created above.    [2 marks]

A3: What do the graph and table tell you about the number of diamonds in the colour grades?             [2 marks]

Part B: Exploratory analysis of price of the diamonds [14 marks]

B1: Use Excel to draw a boxplot of the prices of the diamonds in the sample. [2 marks]

B2: Use Excel to draw a histogram of the prices of the diamonds in the sample. [2 marks]

B3: Use Excel to calculate the numerical summaries of the prices in the sample. Fill in the table with the values rounded appropriately in the column labelled “Price ($NZ)” and the Excel formula you used in the column labelled “Excel Formula Used”. [2 marks]