Prepared Data from the Original Data with all Unnecessary Data Removed - Science Assignment Help

Assignment Task:

Task:

Instructions:

 1. Read through the background information provided for each part.

2. Read the questions that you must answer with the provided data.

3. Document your working by using a separate sheet in excel for each question, the sheet should include the following:

• Prepared data from the original data with all unnecessary data removed.

• Any calculation using formula

• Any scatterplots fully labelled

• Neat headings and labels for all data and working 

4. Document your answer in the provided template word document. You should include the following:

• All written responses.

• Summaries of calculations from excel, including what formulas you used and substitutions.

• The appropriate scatterplots from excel with correct reference within text. 
 

PART 1: LINEAR ANALYSIS OF DATA Background information:

 Every diamond is unique, and there are a variety of factors which affect the price of a diamond. The weight of a diamond stone is indicated in terms of carat units and larger diamond stones command higher prices in view of their rarity. 
The clarity of a diamond tells of its purity. Being products of nature, diamonds have inclusions only visible under a jeweller's magnifying glass or a microscope. Diamonds with no inclusion under a loupe with a 10 power magnification are labelled IF ("internally flawless"). Lesser diamonds are categorised in descending order as "very very slightly imperfect" VVS1 or VVS2 and "very slightly imperfect" VS1 or VS2. 
The most prized diamonds display colour purity. They are not contaminated with yellow or brown tones. Top colour purity attracts a grade of D. Subsequent degrees of colour purity are rated E, F, G... all the way down the alphabet ladder. 
The cut of a raw diamond stone relies on the experience and the craftsmanship of the diamond cutter. A variety of different shapes are achieved — the most common being the round cut diamond shape. The optimal cut should neither be too deep nor too shallow.

The above  Science  Assignment has been solved by our  Science Assignment  Experts at onlineassignmentbank. Our Assignment Writing Experts are efficient to provide a fresh solution to this question. We are serving more than 10000+ Students in Australia, UK & US by helping them to score HD in their academics. Our experts are well trained to follow all marking rubrics & referencing style.

Be it a used or new solution, the quality of the work submitted by our assignment experts remains unhampered. You may continue to expect the same or even better quality with the used and new assignment solution files respectively. There’s one thing to be noticed that you could choose one between the two and acquire an HD either way. You could choose a new assignment solution file to get yourself an exclusive, plagiarism (with free Turnitin file), expert quality assignment or order an old solution file that was considered worthy of the highest distinction.