The Coke Lab

at
Categories
Tags

 

 

 

Turn to the The Coke Lab (pg 56) in the DVC CHEM 120 Lab Manual. Please read through the background on error analysis (pg 57-60) before watching the prelab videos.
Watch the following Prelab video on error in measurement and fill out the prelab notes as you go along:
Error in Measurement (Links to an external site.)
View the following videos to learn functionalities in Excel that will help you complete the analysis for the Snapple and Diet Snapple data sets. Write any notes in the space below.
Orientation to the Class Data Spreadsheet for this assignment (Links to an external site.)
Sorting Data and Formatting Cells in Excel (Links to an external site.)
Performing Calculations from Preprogrammed Functions in Excel (Links to an external site.)
Programming Functions in Excel (Links to an external site.)
(Links to an external site.)Showing Formulas in Excel (Links to an external site.)
Performing the Q test on a large data set in Excel (Links to an external site.)
Download the class data spreadsheet from Canvas by clicking this link.Preview the document You must take the class sets for BOTH Snapple tab and Diet Snapple tab and do the following in Excel:
Sort the cells to display the values from smallest to largest.
Format the cells to display the proper number of significant figures for the density calculated by each volume measuring method.
Apply the Q test calculations to both data sets to determine if any data point is an outlier and can be excluded from analysis. LIST any data point that you excluded in the spreadsheet by that label. DELETE any value you determined could be excluded by the Q-test. Note: Calculated values will automatically change when you delete outliers!
Create a table in the Excel spreadsheet with calculated values using programmed functions (Average and Standard Deviation) and user-created formulas (% Error and % Relative Standard Deviation) for each data set. The true density value for Snapple is 1.033 g/mL. The true density value of Diet Snapple is 0.998 g/mL. The lab manual tells you the true values of Coke and Diet Coke!
Review the calculated values (corrected by exclusion using the Q test), and Type your answer to the following Post-Lab Questions in a Word Document. See rubric for grading.
What is the significance of three standard deviations from an average for a set of data. Using your understanding of this significance and the calculated values from this laboratory, determine if the following two numbers are densities of coke, diet coke, or neither: 1.005 g/mL, 1.020 g/mL. Explain using the terms average, standard deviation, and probability.
Using the Snapple and Diet Snapple scatter graphs in the class data spreadsheet, rate the precision and accuracy for each of the three density determinations. The actual density of Snapple and Diet Snapple are 1.033 g/mL and 0.998 g/mL respectively. Use descriptive words about the appearance of the graph. This is a qualitative analysis of precision and accuracy.
Compare and contrast the mathematical approach to determining accuracy and precision (the calculated values or quantitative analysis) with the graphical approach (the scatter plot and qualitative analysis). Do you observe visual differences in the data’s quality relative to the calculated values alone? Explain.
Would it be more precise to transfer 25.00 mL (note sig figs) using a 25 mL volumetric pipet or a 50 mL buret having an uncertainty ±0.02 mL buret? Consider the buret requires two measurements. Explain in 2-3 complete sentences with a discussion of uncertainty in your explanation.
How do the experimental density values compare to the accepted values reported in the lab? Why might the experimental values be low especially for the graduate cylinder? Explain in 2-3 complete sentences. Use a description of error in your explanation. You should use the term random or systematic error, and the error you describe should explain why the experimental values are LOW!
Lab Report Expectations: Upload the Class Data spreadsheet including your data sort, calculations, Q test results, and graphs. Also Upload a word document or PDF with your answers to the assigned post lab question (TYPED) for a total of 2 files. For instructions on how to upload multiple files to Canvas, click here (Links to an external site.).
Peer Review: This assignment includes a peer review. You will be assigned 2 peer reviews with this assignment. That means after the due date for this assignment, Canvas will assign you two peers to review. To learn more about how to give and receive feedback in a Peer Review, click here (Links to an external site.). (In a separate assignment, you will be allowed to edit your post lab questions incorporating the peer review feedback and resubmit your responses. Please review all of your feedback!) To complete the peer review, do the following:
(2 pt) Provide 2 or more annotations within your peer’s Post Lab Question document submission that tell your peer ways they could make their language clearer or to correct their analysis.
(1 pt) Provide 1 overall comment in the comment box for your peer based on your impressions of their submission.
There are a total of 6 points associated with this peer review process (3 points for each peer review) in this assignment rubric.

 

 

Sample Solution

nother recommendation GCS should implement would be to review their training and development plan that they offer to new recruits of the firm. Currently, the new consultants will progress through a basic scheme starting with being a Telecanvasser for six weeks, this involves “phoning up clients to ask if they have any vacancies” (King, Chung & Hunter, 2014). The employee would then progress through the organisation in order to reach the goal of being a recruitment consultant, which is likely to take 3 to 9 months. Even though, GCS hire employees that they believe to possess traits that make a successful consultant and provide basic training for the first 3 to 9 months. Once the employee’s reaches the goal of being “a recruitment consultant” and has autonomy over their work, GCS no longer provides a training scheme to allow the individual to continuously develop. This proves to be a problem for GCS and their value proposition, operational excellence, as the business environment is dynamic, therefore constantly changing, in order to stay competitive, they will need to provide their staff with extensive training that is up-to-date and relevant for the consultants. This will increase their knowledge and skill base allowing GCS be more likely to achieve their business goals, increase the overall performance of the firm and more likely to receive repeat business as clients will have trust in the consultants. Therefore, allowing the staff to have an opportunity to perform and excel within their role. All of which allows GCS to gain competitive advantage within the market. This can help the company achieve the overall organisational goal of “keeping the top performing consultants motivated” (King, Chung & Hunter, 2014). Implementing this recommendation will fit in with the strategic-fit approach that the firm has adopted, it will allow the firm to be achieve their business and HR goals, this aligns with the vertical fit of the strategic approach. In addition, investing time and money into the employee’s, this will increase their motivation and ability for their job and GCS, meaning that consultants will feel more valued and more likely to stay committed to the firm, t

This question has been answered.

Get Answer