excel homework Histograms

User Generated

dhrfgvbaf

Economics

Description

the instructions is in one of the files attached the first part of the homework is done witch is testing and culcting the data witch is all ready done and the data is in the second attached file. and the team i was a part of is team 4

hw13_-_histograms_-_paperclip_experiment.docx 

post_to_hw13_-_paperclip_data_collection.xls 

Unformatted Attachment Preview

PART I: Collect Experimental Data • • • • Bend the provided 30 paper clips until they fail. o Follow the instructions presented in class on how to bend the paperclips. Record the number of bends until failure for all 30 clips Determine the frequency of failure from 1 to 20 bends o If the paperclip lasts more than 20 bends, note their frequency in the “20+ bends” row, and mention the frequency of this result in your paper. Record any additional observations about the paperclips that might be useful. PART II: Organizing the Data Create: 1. A table and histogram (using EXCEL) from your team’s data (30 paperclips). 2. A table and histogram (using EXCEL) from the data collected from the entire class (300 paperclips). 3. A table and histogram (using EXCEL) from the data collected from all 8 sections of EGR 186 (2400 paperclips). Be sure your graphs are appropriately scaled. i.e., don't compare the # of bends of a group (30 paperclips) to the entire class (300 paperclips). If you want to compare 30 paperclips to 300, convert to %. PART III: Presenting the Experiment Write a report to explain the experiment, show the data collected, and discuss the results. 1. Include a cover page with appropriate information. 2. The report must contain a 1) problem statement, 2) methods section, 3) results section, and 4) conclusion (make a conclusion by writing a short paragraph to answer the provided questions). a. Conclusion: discuss your observations regarding the frequencies of paperclip failure. i. Is there a distinct trend or trends? ii. Discuss why such a result may have occurred (re-examine the paperclips for any possible clues to the trends observed). PAPER FORMAT NOTES: • Write your paper in 3RD PERSON! i.e “The data show…”, NOT “I saw a trend in the data…”. In engineering technical papers, the data is the focus (not you…). • Properly label title and axes of every graph. No legend is required. • Explain what each graph and table is in the text. Refer to each graph in the text (Figure 1, Figure 2, Table 1, etc.). • Each graph must also have a caption centered directly BELOW the figure (i.e. Figure 1: Team results of…). • Each table must have a caption centered directly ABOVE the table (i.e. Table 1: Team results of…). • Refer to the journal articles you read for the Tech Comm Project for format, header, figure, table, and caption examples. Page 1 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 20+ Fre qu en cy Te am Cli pB en ds DATA FOR FIFTY ROLLS OF THREE DICE 1 2 3 4 5 6 7 8 9 10 61 2 6 5 16 8 17 9 5 13 7 11 5 7 5 7 6 5 3 3 9 210 68 6 8 4 7 11 7 8 10 19 4 12 1 12 3 3 3 3 4 4 13 210 58 9 8 3 7 8 12 8 8 8 5 19 3 9 6 7 7 4 4 3 14 210 53 13 8 11 11 18 5 16 14 12 10 6 8 4 2 3 1 2 1 1 11 210 61 9 7 8 7 7 8 7 9 12 7 4 6 10 4 8 8 4 1 5 18 210 56 3 5 7 9 16 13 7 10 4 12 4 3 9 5 3 5 2 3 7 27 210 59 7 9 9 10 15 8 11 8 11 2 12 3 8 6 6 4 6 1 1 14 210 53 3 4 8 16 10 14 11 6 11 2 5 4 2 5 0 4 3 5 0 14 180 48 10 12 19 12 11 10 4 11 6 2 6 2 1 9 4 2 2 1 3 5 180 56 5 9 7 7 9 4 6 9 12 7 3 3 3 8 4 3 2 3 2 18 180 To tal DATA FOR FIFTY ROLLS OF THREE DICE All Teams 573 67 76 81 102 113 98 87 90 108 58 82 38 65 53 45 43 33 26 29 143 2010 paperclips 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 20+ Fre qu en cy Te am Cli pB en ds DATA FOR FIFTY ROLLS OF THREE DICE 1 2 3 4 5 6 7 8 9 10 10 0 1 0 1 1 1 0 1 1 2 4 0 2 0 1 1 1 0 2 1 30 10 0 3 2 1 3 4 2 1 2 0 1 0 0 0 1 0 0 0 0 0 30 9 1 3 1 1 2 3 2 1 3 0 0 0 1 0 1 0 0 0 0 2 30 9 1 0 1 3 6 0 3 0 0 2 1 0 0 0 1 0 0 0 0 3 30 10 0 0 0 0 0 0 0 0 1 1 2 0 2 2 2 1 0 1 1 7 30 8 1 1 1 2 5 0 1 2 2 1 0 1 0 0 0 1 0 0 0 4 30 7 0 1 2 4 5 2 1 2 1 1 0 0 1 0 0 0 1 0 0 2 30 7 1 2 0 3 2 4 1 1 1 1 0 0 0 0 0 2 1 1 0 3 30 6 1 2 0 4 1 3 0 2 1 0 2 1 0 4 1 0 0 0 0 2 30 9 0 1 0 2 3 1 1 0 2 3 0 1 0 2 0 0 0 0 0 5 30 To tal DATA FOR FIFTY ROLLS OF THREE DICE All Teams 85 5 14 7 21 28 18 11 10 14 11 10 3 6 8 7 5 3 2 3 29 300 paperclips 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 20+ Fre qu en cy Te am Cli pB en ds DATA FOR FIFTY ROLLS OF THREE DICE 1 2 3 4 5 6 7 8 9 10 7 0 2 1 1 1 0 3 0 5 1 1 2 0 2 0 0 0 1 1 2 30 9 1 0 1 1 2 0 0 2 3 0 1 0 1 2 0 0 0 3 0 4 30 10 0 0 1 0 1 0 0 4 1 2 4 1 1 1 0 0 0 0 1 3 30 4 4 3 0 0 2 2 4 2 3 1 0 0 0 0 0 0 0 0 0 5 30 8 1 0 1 1 1 0 0 2 4 0 0 2 0 0 3 3 1 0 0 3 30 7 0 2 0 2 5 2 0 1 0 1 2 0 0 2 0 1 0 0 1 4 30 7 3 0 0 0 0 0 1 1 1 0 3 0 1 3 2 2 1 1 1 3 30 8 1 0 0 3 0 1 2 0 3 1 1 1 1 0 0 0 1 1 0 6 30 6 3 1 0 0 1 2 1 2 3 0 0 1 0 3 2 1 2 0 1 1 30 7 2 2 2 1 4 1 1 0 0 1 1 0 0 1 0 1 0 0 0 6 30 To tal DATA FOR FIFTY ROLLS OF THREE DICE All Teams 73 15 10 6 9 17 8 12 14 23 7 13 7 4 14 7 8 5 6 5 37 300 paperclips 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 20+ Fre qu en cy Te am Cli pB en ds DATA FOR FIFTY ROLLS OF THREE DICE 1 2 3 4 5 6 7 8 9 10 6 1 1 0 4 3 5 2 2 1 0 1 0 1 0 1 0 1 0 0 1 30 11 0 1 0 1 2 1 0 0 5 0 0 0 1 0 0 0 0 0 1 7 30 6 0 2 0 0 2 2 1 0 2 0 3 1 2 0 1 3 1 2 1 1 30 6 2 0 1 3 2 1 3 0 3 1 2 2 0 0 0 1 2 0 0 1 30 7 1 2 0 1 2 0 1 1 2 0 0 0 2 0 1 0 2 0 3 5 30 9 1 0 0 0 0 1 0 1 1 0 0 0 2 0 2 1 0 2 2 8 30 10 0 1 0 2 1 0 0 0 1 0 4 0 2 0 0 2 3 0 0 4 30 0 0 0 To tal DATA FOR FIFTY ROLLS OF THREE DICE All Teams 55 5 7 1 11 12 10 7 4 15 1 10 3 10 0 5 7 9 4 7 27 210 paperclips 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 20+ Fre qu en cy Te am Cli pB en ds DATA FOR FIFTY ROLLS OF THREE DICE 1 2 3 4 5 6 7 8 9 10 10 0 0 0 0 1 1 0 0 2 2 2 2 0 1 3 2 2 1 0 1 30 10 0 0 1 0 1 0 2 2 3 1 3 1 2 0 0 1 1 0 0 2 30 7 4 1 0 2 1 5 0 0 0 0 3 1 1 3 0 1 0 0 0 1 30 6 3 3 2 0 2 0 2 4 1 1 1 0 2 1 0 0 0 0 0 2 30 10 0 0 0 0 0 0 2 2 3 3 0 0 3 1 1 4 0 0 1 0 30 10 0 1 3 0 1 3 1 0 0 1 0 0 0 0 0 0 0 1 1 8 30 8 0 1 0 1 1 0 0 2 3 0 1 3 1 3 2 0 0 0 0 4 30 10 0 0 2 2 3 2 5 2 1 0 2 1 0 0 0 0 0 0 0 0 30 10 0 0 1 3 4 3 1 4 1 2 0 0 1 0 0 0 0 0 0 0 30 10 0 0 0 0 0 1 1 1 2 1 1 0 2 3 3 0 1 0 1 3 30 To tal DATA FOR FIFTY ROLLS OF THREE DICE All Teams 91 7 6 9 8 14 15 14 17 16 11 13 8 12 12 9 8 4 2 3 21 300 paperclips Fre qu en cy Te am Cli pB en ds DATA FOR FIFTY ROLLS OF THREE DICE 1 2 3 4 5 6 7 8 9 10 0 0 0 0 0 0 0 0 0 0 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 20+ To tal DATA FOR FIFTY ROLLS OF THREE DICE All Teams 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 paperclips 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 20+ Fre qu en cy Te am Cli pB en ds DATA FOR FIFTY ROLLS OF THREE DICE 1 2 3 4 5 6 7 8 9 10 8 1 0 0 3 0 7 1 0 2 1 1 1 3 0 1 0 0 0 0 1 30 8 0 2 0 1 1 1 0 3 3 1 2 0 6 1 0 1 0 0 0 0 30 6 3 0 0 0 0 1 0 0 1 3 5 0 1 1 1 2 3 2 1 0 30 7 1 2 0 0 3 2 2 5 3 2 1 2 0 0 0 0 0 0 0 0 30 6 2 1 3 1 2 3 0 2 0 2 1 4 1 0 1 0 1 0 0 0 30 2 0 0 1 1 0 0 1 4 0 3 1 2 3 3 1 1 2 0 2 3 30 7 0 1 3 0 5 2 3 1 2 1 2 0 1 0 0 0 1 0 0 1 30 9 1 1 2 2 1 2 3 3 3 0 1 1 1 0 0 0 0 0 0 0 30 8 2 6 10 2 2 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 30 10 0 0 0 1 0 0 1 6 4 2 1 2 1 0 0 0 1 0 0 1 30 To tal DATA FOR FIFTY ROLLS OF THREE DICE All Teams 71 10 13 19 11 14 18 11 24 18 15 15 12 17 5 4 4 8 2 3 6 300 paperclips 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 20+ Fre qu en cy Te am Cli pB en ds DATA FOR FIFTY ROLLS OF THREE DICE 1 2 3 4 5 6 7 8 9 10 10 0 0 3 3 0 3 2 1 1 0 2 0 1 1 1 0 1 0 0 1 30 10 0 0 0 0 2 0 2 2 0 0 5 0 2 0 2 1 2 0 2 0 30 10 0 0 0 1 2 1 2 3 1 0 4 0 1 1 1 0 0 0 0 3 30 10 0 0 3 3 1 0 1 3 2 3 0 2 0 0 1 0 0 0 1 0 30 9 1 1 2 0 2 2 1 2 2 1 1 0 2 1 0 0 0 0 0 3 30 10 0 0 0 2 4 4 4 0 0 4 1 0 1 0 0 0 0 0 0 0 30 9 0 0 3 1 2 2 3 2 2 0 2 0 2 0 2 0 0 0 0 0 30 9 0 1 1 5 3 2 0 0 3 0 0 0 0 2 0 2 1 0 0 1 30 8 2 2 4 1 2 1 2 2 1 0 2 0 0 0 1 0 0 0 0 2 30 10 0 3 0 3 0 0 1 1 2 0 0 0 0 2 0 1 0 3 1 3 30 To tal DATA FOR FIFTY ROLLS OF THREE DICE All Teams 95 3 7 16 19 18 15 18 16 14 8 17 2 9 7 8 4 4 3 4 13 300 paperclips 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 20+ Fre qu en cy Te am Cli pB en ds DATA FOR FIFTY ROLLS OF THREE DICE 1 2 3 4 5 6 7 8 9 10 10 0 2 1 4 2 0 1 1 1 1 0 0 0 1 0 3 0 1 0 2 30 10 5 2 0 3 0 1 2 0 3 2 0 0 0 0 0 0 0 1 1 0 30 10 1 2 1 3 0 0 3 0 0 0 0 0 2 0 3 1 0 0 0 4 30 11 2 0 4 2 2 0 1 0 0 0 1 2 2 1 1 0 0 1 0 0 30 11 4 3 2 4 0 3 3 0 0 0 0 0 0 0 0 0 0 0 0 0 30 10 1 1 2 2 1 3 0 2 1 2 0 0 3 0 0 1 0 0 1 0 30 11 4 5 1 2 1 2 3 0 1 0 0 0 0 0 0 0 0 0 0 0 30 10 0 0 3 1 1 3 0 0 0 0 1 1 0 3 0 0 0 3 0 4 30 10 2 1 4 2 1 1 0 1 0 0 2 0 0 2 0 1 0 1 2 0 30 10 3 3 5 0 2 1 1 1 2 0 0 0 0 0 1 1 0 0 0 0 30 To tal DATA FOR FIFTY ROLLS OF THREE DICE All Teams 103 22 19 23 23 10 14 14 5 8 5 4 3 7 7 5 7 0 7 4 10 300 paperclips Fre qu en cy Te am Cli pB en ds DATA FOR FIFTY ROLLS OF THREE DICE 1 2 3 4 5 6 7 8 9 10 0 0 0 0 0 0 0 0 0 0 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 20+ To tal DATA FOR FIFTY ROLLS OF THREE DICE All Teams 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 paperclips
Purchase answer to see full attachment
User generated content is uploaded by users for the purposes of learning and should be used following Studypool's honor code & terms of service.

Explanation & Answer


Anonymous
Great study resource, helped me a lot.

Studypool
4.7
Trustpilot
4.5
Sitejabber
4.4

Related Tags