STATISTICS technology assignments

profileOcean
StatisticsTechnologyAssignments.docx
Home>Business & Finance homework help>Accounting homework help>STATISTICS technology assignments

Statistics Technology Assignments:

**EACH ONE IS ITS OWN ASSINGMENT DO NOT BLEND THESE ANSWERS TOGETHER!! SUBMIT EACH ANSWER SEPERATELY ON ITS OWN WORD DOCUMENT!!

WEEK 1 TECHNOLOGY ASSIGNMENT

Collecting data and creating graphs - Collect data from 30 people from your work, school, neighborhood, family, or other group.  Ask a quantitative question, such as, “How many pets do you have?” or “How many college classes have you taken?”   Explain your population, sample, and sampling method and what level of measurement your data is (nominal, ordinal, interval, or ratio).  Use technology (StatCrunch, Statdisk, or Excel) to create a Histogram of your data and explain the shape of the distribution (bell-shaped, uniform, right-skewed, or left-skewed) and possible reasons why the distribution is this shape.  Explain the importance of this data, what you find interesting about the data, and why the public should know. Look up a newspaper, e-pub, or journal article that confirms or denies the results of your small study.

SAVE THIS DATA TO BE USED IN FUTURE WEEK’S TECHNOLOGY ASSIGNMENTS!

WEEK 2 TECHNOLOGY ASSIGNMENT

Generating Summary Statistics - Using the data you collected last week, use technology (StatCrunch, Statdisk, or Excel) to find the mean, median, mode, standard deviation, and five number summary.  Explain how these statistics describe your data and what they suggest about your sample.  Create a boxplot of the data and identify any outliers in your data by using the methods on page 121 of your textbook and discuss how those outliers are affecting your results (provided picture of page 121 below)

WEEK 3 TECHNOLOGY ASSIGNMENT

Calculating Binomial Probabilities - Suppose you work for an airline and you are taking reservations for a flight on an aircraft that has 152 seats.  You know, based on historical flights trends, that if you sell a single ticket there is a 91% chance that the person with the ticket will actually show up for the flight.  You decide to try to make a little extra money by overbooking your flight and you sell 160 tickets hoping that not more than 152 people will actually show up for the flight (note: this is a common business practice!  Click here to watch a video that explains why)

Explain how this scenario meets the four requirements in the definition of a Binomial Distribution (page 200) provided here.

Identify what n and p are in this example

Use technology (StatCrunch, Statdisk, or Excel) to calculate the probability that if you sell 160 tickets for your flight, more passengers will show up than there are seats available (again, the plane has 152 seats total).  Post an image of your technology output using the Insert/Edit Image feature in Blackboard (no attachments!)

Based on this probability, do you think it is a wise business practice to oversell your flight in this manner?   Explain.

WEEK 4 TECHNOLOGY ASSIGNMENT

Determining Normality - Download the data set “Body Data” in your preferred technology format (StatCrunch, Statdisk, Excel).  Select 3 columns of your choice from the list below.  For each of the 3 columns you selected, determine whether the data is normally distributed in two ways:  1. Create a Histogram of the data and determine if it is approximately bell-shaped, and 2. Create a Normal Quantile Plot and determine if the pattern of points is reasonably close to a straight line.  After examining these two graphs together, decide whether the data is normally distributed and explain your findings.  Paste your graphs using the Insert/Edit Image button (no attachments!)

 

 

Pulse (pulse rate in beats per minute)

HDL (HDL cholesterol, mg/dL)

LDL (LDL cholesterol, mg/dL)

White (white blood cell count, 1000 cells/µL)

Red (red blood cell count, million cells/µL)

Weight (weight, kg)

Height (height, cm)

Waist (waist circumference, cm)

Arm Circ (arm circumference, cm)

BMI (body mass index, kg/m2)

WEEK 5 TECHNOLOGY ASSIGNMENT

Confidence Intervals - Filtered cigarettes are allegedly healthier than nonfiltered cigarettes.  One reason for this is because they contain less tar.

Download the data set “Cigarette Contents” in your preferred technology format (StatCrunch, Statdisk, Excel).  Column 1 denotes the amount of tar per cigarette (milligrams) in king-sized cigarettes that are nonfiltered.  Column 4 denotes the amount of tar per cigarette (milligrams) in menthol cigarettes that are filtered. 

Using technology (StatCrunch, Statdisk, or Excel) compute a 95% confidence interval for the mean amount of tar in each cigarette group and paste the screen printouts obtained from the technology.  Post an image of your technology output using the Insert/Edit Image feature (no attachments!)  Describe in words what each confidence intervals represents.  

Compare the confidence intervals obtained for the filtered and nonfiltered cigarettes.  Based on your confidence intervals, do you see evidence that the filtered cigarettes are healthier?  Explain.

 

WEEK 6 TECHNOLOGY ASSIGNMENT

Hypothesis Test - Download the data set “Airport Speeds” in your preferred technology format (StatCrunch, Statdisk, Excel).  Column 2 denotes the data speeds (Mbps), taken from 50 different airports, for the carrier Verizon.  Column 4 denotes the data speeds (Mbps) for the carrier AT&T from the same 50 airports.

Using technology (StatCrunch, Statdisk, or Excel) compute the mean data speed for each of the two carriers, Verizon and AT&T.  Provide a printout of your technology output using the Insert/Edit Image feature (no attachments!)    Based on this, which carrier do you think has the faster speed?

Next, using technology (StatCrunch, Statdisk, or Excel) conduct a hypothesis test to test your claim about which carrier has the faster speed.  Explain which test you conducted and why that is the appropriate test for this example.  Provide a printout of your technology output using the Insert/Edit Image feature (no attachments!) Explain your conclusion in statistical and non-statistical terms and how you arrived at that conclusion.  Be sure to follow the 8-step procedure on page 360, using technology to do your calculations.  You should include your null and alternative hypothesis (in English and in symbolic form), your significance level, whether you are conducting a right tailed, left tailed, or two tailed test, p-value, and conclusions.

 

WEEK 7 DISCUSSION BOARD

Correlation - There was a not a placement test for this class, but do you think there would be a positive correlation between a placement test score and the final grade in this class?  What other variables do you think would have a positive correlation with the final grade in this (or any) class?  What variables would have a negative correlation with a final grade in a class?  Look up a study that finds a correlation between grades and some other variable.  Describe the variables, the study, the methods used, whether the correlation is positive or negative, and how this relates to your life.  Be sure to provide a reference! 

Body

Data_Excel(1).xlsx

01 - Body Data

AGE GENDER (1=M) PULSE SYSTOLIC DIASTOLIC HDL LDL WHITE RED PLATE WEIGHT HEIGHT WAIST ARM CIRC BMI
43 0 80 100 70 73 68 8.7 4.80 319 98.6 172.0 120.4 40.7 33.3
57 1 84 112 70 35 116 4.9 4.73 187 96.9 186.0 107.8 37.0 28.0
38 0 94 134 94 36 223 6.9 4.47 297 108.2 154.4 120.3 44.3 45.4
80 1 74 126 64 37 83 7.5 4.32 170 73.1 160.5 97.2 30.3 28.4
34 1 50 114 68 50 104 6.1 4.95 140 83.1 179.0 95.1 34.0 25.9
77 1 60 134 60 55 75 5.7 3.95 192 86.5 166.7 112.0 31.4 31.1
29 1 52 118 64 53 128 4.1 4.68 191 64.1 178.5 78.0 27.4 20.1
69 0 58 138 80 40 140 8.1 4.60 286 79.2 155.7 103.5 34.2 32.7
44 0 66 114 66 45 136 8.0 4.09 263 64.2 157.6 89.7 32.5 25.8
35 1 62 124 70 62 110 5.6 5.47 193 118.8 180.4 112.0 40.0 36.5
79 1 52 138 58 54 92 8.3 4.44 193 71.3 166.3 95.0 32.7 25.8
72 0 56 110 72 53 102 6.9 4.15 215 98.2 168.6 115.3 38.5 34.5
18 1 76 116 40 45 79 5.1 5.07 162 122.7 181.1 118.8 41.2 37.4
65 1 52 134 66 41 100 9.5 4.38 646 75.3 170.0 92.6 30.4 26.1
37 0 82 100 80 55 94 8.1 5.22 250 51.8 164.0 75.5 27.0 19.3
29 0 78 92 58 64 124 6.4 4.22 386 76.1 159.5 101.8 32.9 29.9
30 1 62 124 66 30 47 6.1 4.32 265 89.5 180.8 92.5 36.2 27.4
44 0 86 100 50 59 119 6.3 4.30 218 75.9 155.4 100.8 33.5 31.4
51 0 88 106 72 67 129 10.9 6.34 503 67.1 178.8 82.8 26.6 21.0
50 1 72 158 82 53 102 5.7 5.60 193 86.9 174.7 92.9 36.7 28.5
63 1 60 132 74 43 88 5.4 4.93 144 91.1 171.9 109.0 34.7 30.8
23 1 64 116 54 58 138 8.6 5.18 304 96.4 175.9 101.9 37.0 31.2
66 0 56 122 88 49 81 4.8 3.54 350 81.4 155.6 110.0 36.5 33.6
65 1 78 132 76 51 123 3.8 4.61 180 86.3 179.8 102.3 33.0 26.7
46 0 36 138 68 62 140 5.9 4.22 329 54.4 149.0 80.0 29.9 24.5
70 1 82 128 52 38 200 11.0 4.99 268 72.3 182.9 94.3 29.5 21.6
59 1 66 134 90 45 123 8.1 5.23 193 78.5 169.3 103.1 34.5 27.4
31 0 66 112 60 53 90 7.2 4.01 189 70.9 155.6 103.0 32.0 29.3
35 0 84 122 72 52 98 6.8 4.07 243 60.5 156.8 90.5 29.0 24.6
40 1 66 134 78 42 164 4.6 5.06 203 75.9 161.6 88.2 36.0 29.1
55 0 76 106 62 74 140 5.5 4.30 250 55.6 154.8 78.8 29.0 23.2
22 0 78 104 66 64 85 6.1 4.28 186 46.9 155.5 65.8 23.7 19.4
51 0 64 158 88 32 156 4.7 4.76 392 93.5 155.0 114.4 35.1 38.9
26 0 66 94 56 52 56 5.3 4.14 194 50.4 154.9 78.0 25.2 21.0
62 0 78 144 84 87 168 4.5 4.61 233 86.8 161.5 106.8 35.4 33.3
74 1 96 128 80 42 90 4.6 4.67 210 87.8 166.2 112.4 34.5 31.8
43 0 60 120 70 51 94 5.6 4.36 230 69.8 160.0 94.8 34.9 27.3
56 0 64 112 62 62 150 3.7 4.28 215 57.8 163.6 90.6 25.5 21.6
54 0 84 100 70 62 152 4.8 4.59 222 73.5 164.7 95.2 31.8 27.1
20 0 82 116 72 58 65 8.8 4.77 169 57.8 170.2 71.5 24.5 20.0
80 1 42 162 60 50 99 7.4 3.86 230 59.5 155.0 94.5 28.3 24.8
18 1 86 110 72 34 132 9.8 5.38 239 81.3 178.4 95.3 31.0 25.5
30 1 72 122 80 38 137 9.6 5.03 240 88.3 176.7 103.5 34.7 28.3
63 0 70 130 88 44 190 6.2 4.60 337 72.7 154.6 104.2 30.0 30.4
64 0 74 130 70 87 98 6.3 4.46 240 66.5 159.5 88.7 35.0 26.1
78 0 86 112 66 53 164 5.6 5.06 274 85.9 167.1 109.7 34.9 30.8
55 1 64 154 102 48 91 8.0 4.05 175 102.6 174.9 115.0 36.8 33.5
18 0 90 92 68 77 85 5.6 4.38 254 39.0 156.8 64.4 20.5 15.9
40 0 88 108 70 35 73 10.4 4.01 575 105.3 169.5 133.5 39.0 36.7
39 1 72 128 60 37 155 8.9 5.08 218 94.7 178.2 102.2 39.3 29.8
21 1 72 124 78 42 113 8.8 5.23 277 144.9 183.1 138.1 38.6 43.2
39 0 90 108 82 36 95 5.4 5.36 158 92.8 170.9 112.1 38.0 31.8
68 0 90 132 74 95 113 6.6 4.11 186 45.2 151.6 70.2 24.7 19.7
51 0 94 120 90 71 98 14.3 4.64 247 150.4 159.7 144.4 46.3 59.0
18 0 68 120 62 62 97 9.7 3.76 395 71.5 158.4 95.7 29.2 28.5
35 1 54 126 72 68 100 5.6 4.79 253 84.1 172.9 98.7 35.3 28.1
44 1 66 128 84 40 122 8.1 5.28 218 112.8 174.6 121.7 37.4 37.0
18 0 90 106 70 66 76 6.6 3.86 217 74.0 173.6 87.4 28.0 24.6
20 0 82 110 76 78 140 5.5 3.91 238 64.0 160.1 77.7 27.0 25.0
45 0 80 146 90 45 112 6.3 4.41 198 92.8 164.8 100.9 35.6 34.2
51 0 74 128 86 47 112 6.8 4.04 201 85.9 172.1 93.4 33.7 29.0
63 0 56 156 60 52 121 7.1 4.19 204 105.5 153.2 125.9 37.3 45.0
37 1 56 114 64 57 71 5.0 4.88 204 123.9 184.3 121.2 39.5 36.5
80 1 80 96 68 47 58 5.1 3.90 265 76.5 182.0 90.5 27.7 23.1
80 0 100 122 78 65 120 7.0 3.53 227 43.3 134.5 86.7 23.6 23.9
18 1 72 120 56 47 87 6.4 5.08 232 71.7 188.4 82.3 26.5 20.2
62 1 64 136 84 43 79 5.9 4.67 213 90.0 174.3 107.3 34.1 29.6
41 1 64 106 78 63 133 5.3 5.16 249 70.6 168.5 88.2 32.2 24.9
59 0 74 124 82 63 119 8.7 4.92 219 114.9 169.1 129.3 40.8 40.2
36 1 96 114 56 97 251 4.9 3.74 166 64.8 180.3 78.8 25.7 19.9
80 1 58 136 62 34 69 10.0 4.14 208 76.6 172.2 95.0 29.5 25.8
33 0 76 108 78 45 111 5.6 4.11 183 89.1 160.2 102.8 34.1 34.7
60 0 76 136 84 86 95 5.6 4.59 252 58.5 157.8 85.3 25.5 23.5
38 0 86 112 76 49 85 7.0 4.65 318 57.2 166.3 79.6 27.2 20.7
55 1 66 120 66 63 63 6.4 3.76 188 93.7 189.7 101.2 34.2 26.0
68 0 74 136 60 57 135 10.1 4.57 213 81.4 158.4 111.6 32.0 32.4
21 0 66 112 64 63 146 3.5 4.89 243 95.6 177.8 90.8 32.9 30.2
32 1 58 122 72 58 140 7.9 4.92 259 107.4 178.5 108.6 39.5 33.7
27 1 58 120 48 39 86 12.2 4.75 234 74.6 178.7 81.9 30.9 23.4
62 1 68 142 64 26 122 5.9 4.39 110 106.0 180.0 132.2 33.7 32.7
24 1 70 120 76 62 144 7.4 4.80 203 84.4 177.5 87.0 37.2 26.8
37 0 62 110 76 65 148 5.1 4.22 171 86.5 152.4 108.9 37.2 37.2
19 1 84 108 74 41 69 6.4 4.82 232 59.6 181.3 74.5 27.2 18.1
69 0 78 142 60 47 96 8.4 4.22 312 79.1 164.1 107.7 32.5 29.4
46 0 68 112 68 56 143 8.0 4.76 340 68.4 160.6 96.0 29.5 26.5
80 1 58 160 54 74 182 4.6 4.52 263 63.4 172.6 79.5 28.5 21.3
41 0 62 102 64 46 75 7.1 3.99 246 85.7 167.7 111.7 34.0 30.5
27 1 78 118 68 65 158 4.3 4.43 268 70.4 171.5 83.0 28.6 23.9
80 0 62 130 54 62 104 9.2 4.68 213 50.4 158.8 80.6 26.0 20.0
41 0 74 98 66 61 180 8.6 3.79 240 72.1 156.5 102.4 31.2 29.4
68 0 104 140 72 68 99 4.1 3.82 225 77.2 157.6 96.7 33.4 31.1
62 1 66 108 62 44 72 7.0 4.91 196 69.9 166.4 93.0 30.6 25.2
35 1 86 120 68 46 126 5.9 4.38 237 63.7 167.1 88.6 28.0 22.8
24 1 70 106 78 47 104 4.6 4.92 207 90.2 174.2 97.0 40.6 29.7
42 0 54 126 64 66 76 7.3 3.88 373 83.3 169.7 95.4 36.3 28.9
64 0 74 120 72 61 121 4.2 4.49 234 88.6 155.0 104.5 40.5 36.9
28 1 54 128 72 39 123 5.2 5.05 218 99.4 178.6 106.3 36.3 31.2
33 0 74 114 78 40 85 6.5 4.49 228 84.6 170.6 97.2 35.5 29.1
58 1 84 128 74 36 118 12.6 5.80 260 127.8 170.0 140.8 41.6 44.2
18 1 72 128 66 60 84 3.3 4.13 254 88.3 173.5 90.5 33.2 29.3
46 1 74 138 90 42 153 5.6 5.28 154 94.6 173.1 98.6 40.6 31.6
45 1 64 116 66 45 167 5.3 5.19 205 119.8 185.1 115.0 41.5 35.0
27 1 66 112 76 49 146 9.6 5.26 287 78.8 170.5 98.2 32.3 27.1
63 0 84 114 66 64 98 11.4 4.31 309 81.0 160.1 114.5 33.1 31.6
69 1 62 120 48 35 84 5.1 4.82 172 84.4 169.0 108.9 34.8 29.6
60 0 60 186 84 81 99 6.9 4.59 310 53.5 156.4 80.7 26.3 21.9
57 1 62 138 88 46 83 6.8 4.84 206 74.1 166.4 96.9 31.7 26.8
41 0 52 118 60 53 155 5.2 4.32 228 91.7 162.8 95.4 40.0 34.6
61 1 82 168 88 31 116 8.5 4.35 272 89.8 175.5 100.8 37.7 29.2
46 1 54 116 68 46 142 5.5 5.19 285 77.5 167.5 99.1 36.6 27.6
41 0 84 142 94 39 143 9.4 3.72 372 66.2 155.1 88.6 33.8 27.5
65 1 62 126 72 67 93 3.4 3.97 183 69.1 162.4 87.8 35.0 26.2
63 1 54 138 66 49 146 6.3 4.58 235 83.0 164.5 105.6 35.3 30.7
30 1 104 140 74 40 78 7.4 5.67 179 98.9 170.7 103.4 39.6 33.9
64 1 78 136 88 42 126 3.8 4.53 196 91.5 170.4 116.6 35.8 31.5
66 0 66 114 56 82 137 4.6 4.61 186 59.7 166.1 85.7 27.8 21.6
60 0 56 114 76 62 80 4.1 4.09 242 65.3 159.0 90.9 30.2 25.8
19 1 88 118 54 54 113 9.4 5.22 296 78.7 172.5 89.5 33.0 26.4
54 0 66 134 74 84 91 5.7 4.18 289 56.8 148.7 89.0 27.7 25.7
24 0 84 100 58 55 116 5.2 4.11 228 61.5 153.3 77.8 29.3 26.2
57 0 64 154 78 138 143 6.5 4.53 178 65.8 175.1 77.9 26.7 21.5
74 0 64 130 66 54 187 3.9 4.28 262 79.8 164.7 104.0 31.2 29.4
65 0 78 132 92 57 109 6.9 4.43 329 83.0 154.8 105.1 34.9 34.6
18 0 104 122 46 41 90 6.9 4.41 184 63.4 161.2 84.8 29.4 24.4
32 1 76 120 92 39 64 6.5 5.08 235 126.4 183.0 127.7 40.8 37.7
26 0 84 104 46 51 66 4.1 4.30 184 66.6 165.8 81.9 31.1 24.2
29 0 84 120 66 44 131 8.4 4.35 293 126.0 165.6 126.5 39.5 45.9
67 0 62 140 70 52 138 4.6 4.25 229 64.6 166.6 83.0 31.0 23.3
36 0 82 88 56 44 87 6.1 4.32 289 71.7 168.9 96.4 28.6 25.1
63 0 64 132 70 52 171 5.1 4.84 239 103.9 171.8 106.0 38.3 35.2
23 0 78 122 66 61 78 5.3 4.10 216 64.0 160.0 83.7 29.0 25.0
45 1 70 126 82 36 189 5.0 5.13 222 94.8 180.4 101.2 35.5 29.1
39 0 76 108 72 65 142 3.0 4.45 263 78.2 164.6 96.2 35.0 28.9
35 0 86 126 70 54 121 5.5 4.89 206 90.2 159.6 104.6 39.2 35.4
53 0 72 104 66 62 97 3.7 3.84 185 48.3 160.9 77.0 24.5 18.7
59 0 82 130 74 61 148 9.5 5.10 246 87.8 163.3 115.0 30.6 32.9
37 1 66 110 88 54 180 4.3 4.55 188 64.8 169.1 86.1 29.2 22.7
57 1 50 160 94 65 127 6.1 4.55 191 95.1 181.7 102.2 35.7 28.8
25 0 82 106 64 47 117 4.2 4.43 308 77.2 152.0 93.9 34.5 33.4
38 1 40 134 88 44 158 7.3 4.57 262 80.3 178.5 92.4 32.3 25.2
34 1 74 124 88 43 94 4.3 4.58 198 99.5 168.5 110.3 38.5 35.0
31 0 66 112 72 46 134 8.3 4.36 253 110.5 169.1 127.7 45.0 38.6
64 1 74 142 102 83 118 6.0 5.00 256 83.9 177.5 99.1 31.8 26.6
65 1 76 116 70 43 159 5.4 4.52 238 86.2 166.9 109.8 34.1 30.9
47 1 66 120 82 89 136 3.9 4.86 196 81.8 178.6 95.2 31.6 25.6
66 1 66 132 70 37 115 5.9 5.06 232 69.6 167.9 99.0 29.9 24.7
60 0 58 132 56 65 162 7.5 4.47 235 62.4 159.4 87.9 28.7 24.6
57 0 62 142 58 78 135 6.4 3.93 207 105.8 162.2 123.7 39.7 40.2
46 0 80 122 80 64 156 8.1 4.44 265 83.8 170.9 107.2 29.6 28.7
69 0 58 134 72 44 104 3.4 4.40 224 63.6 162.5 86.4 28.2 24.1
76 1 82 102 64 43 68 5.1 5.19 247 77.2 176.3 90.7 30.4 24.8
27 1 64 108 64 49 90 2.7 4.97 230 50.3 167.5 68.8 24.4 17.9
25 0 82 122 70 72 84 4.8 4.03 213 48.0 160.3 68.8 24.0 18.7
63 0 76 120 64 42 113 5.7 4.18 254 89.7 181.4 99.3 31.0 27.3
75 1 84 134 70 35 114 9.0 4.07 210 132.1 173.8 140.6 40.6 43.7
66 0 70 158 66 43 160 4.3 4.05 170 92.0 157.5 119.7 34.3 37.1
36 0 88 122 84 51 98 6.1 3.63 358 62.7 165.6 83.7 28.0 22.9
29 0 44 108 54 44 121 6.9 4.42 167 85.5 169.3 96.6 33.5 29.8
23 1 64 120 70 26 106 6.1 4.48 202 80.7 161.8 99.0 35.0 30.8
19 1 80 112 54 56 82 6.2 4.57 213 81.5 183.5 88.2 32.2 24.2
29 1 62 118 76 57 125 6.4 4.51 279 68.1 168.5 87.5 31.0 24.0
33 1 70 126 64 62 113 5.7 4.76 324 56.7 160.6 81.9 27.9 22.0
54 1 82 120 80 40 147 5.1 5.28 195 73.1 171.9 97.5 27.2 24.7
42 1 78 142 92 66 105 5.2 4.56 228 95.3 171.2 106.6 39.2 32.5
41 1 74 118 80 54 116 4.2 4.82 247 67.6 166.2 91.0 30.0 24.5
51 0 58 128 76 59 100 4.6 3.68 322 52.1 154.1 80.4 25.7 21.9
68 0 64 158 74 63 88 4.9 3.92 170 87.4 167.6 107.8 32.2 31.1
32 0 68 96 52 55 81 9.3 3.51 295 55.2 166.9 76.5 27.0 19.8
70 0 70 156 90 52 126 5.6 4.27 270 89.7 156.6 115.3 34.5 36.6
51 1 64 122 88 42 120 4.4 4.05 218 80.3 173.2 95.3 35.5 26.8
45 0 58 116 58 53 81 7.1 4.26 164 90.3 155.6 109.6 38.1 37.3
61 1 52 136 64 53 98 6.9 4.82 188 89.9 171.7 110.8 38.0 30.5
76 1 60 126 72 68 111 6.0 4.54 175 67.0 170.9 92.9 30.7 22.9
45 0 72 120 82 49 122 5.6 4.57 168 100.4 162.9 114.5 41.2 37.8
47 0 80 130 82 56 146 8.9 4.11 378 95.3 168.8 109.6 37.2 33.4
27 0 70 124 76 42 72 8.9 4.32 219 97.0 157.4 122.9 38.0 39.2
22 0 74 94 66 63 77 8.4 4.48 283 54.5 162.2 78.8 27.3 20.7
60 0 72 126 72 86 96 6.6 4.09 339 74.5 157.3 92.0 33.5 30.1
67 0 66 146 62 52 151 8.4 4.25 243 65.6 162.6 99.5 28.2 24.8
46 1 66 112 78 52 138 9.1 5.43 211 108.8 183.7 114.6 35.2 32.2
62 1 58 102 76 56 171 3.1 4.59 217 69.1 165.7 90.0 30.0 25.2
37 1 74 122 58 113 76 9.1 4.06 216 73.0 170.0 87.1 34.1 25.3
72 1 70 112 66 92 118 5.1 3.91 212 67.6 165.6 93.5 29.4 24.7
31 0 82 134 88 33 112 6.1 4.94 223 140.1 157.0 170.5 45.6 56.8
58 1 66 136 84 27 85 5.8 4.78 176 91.3 169.8 105.8 34.7 31.7
41 0 98 112 56 56 126 11.4 4.32 255 86.2 161.4 100.3 37.8 33.1
41 0 74 110 76 78 117 4.4 4.47 261 72.8 167.7 92.6 29.7 25.9
60 1 72 106 72 43 138 4.4 3.76 136 73.1 180.0 88.3 30.1 22.6
58 1 66 126 68 71 66 5.6 4.53 131 81.7 177.0 110.5 33.4 26.1
56 1 52 130 68 53 162 6.4 5.13 248 99.8 180.5 102.7 39.8 30.6
66 1 82 118 70 34 85 6.6 4.38 177 97.9 171.5 112.5 37.7 33.3
58 0 80 132 76 65 128 4.6 4.80 230 90.4 167.0 105.4 35.0 32.4
41 0 82 126 90 59 80 9.5 4.31 389 115.5 156.5 132.3 44.1 47.2
60 1 66 116 74 48 108 4.1 4.70 225 89.2 179.8 104.3 33.6 27.6
45 1 66 114 72 31 129 6.6 5.23 210 73.1 169.3 94.8 29.1 25.5
61 1 70 114 68 37 121 7.3 5.68 160 64.6 168.2 85.4 29.6 22.8
35 1 68 114 78 41 134 5.9 4.38 196 91.5 185.7 96.5 34.6 26.5
80 1 66 136 68 59 39 7.8 3.99 202 87.1 172.6 109.6 31.5 29.2
52 1 56 124 50 30 175 4.8 5.22 253 95.8 181.1 106.5 38.7 29.2
80 0 56 154 64 90 145 5.8 4.04 240 46.3 156.5 79.8 22.2 18.9
26 1 72 116 66 39 81 6.9 4.93 244 63.9 170.5 84.2 27.5 22.0
22 0 78 112 70 55 80 4.3 4.45 235 72.2 158.4 89.5 32.2 28.8
18 0 100 126 80 58 151 5.5 5.36 233 68.8 167.6 90.1 29.4 24.5
80 1 60 136 72 48 98 5.2 3.96 153 97.5 169.7 116.8 38.5 33.9
54 1 102 144 66 78 130 8.1 4.62 331 127.5 166.6 148.1 44.4 45.9
58 1 74 124 76 49 76 3.5 4.19 149 85.0 186.3 93.4 31.0 24.5
80 0 56 150 42 63 158 5.5 4.54 271 48.5 144.4 77.0 26.4 23.3
21 1 64 110 52 37 124 7.6 5.05 313 109.1 176.6 116.7 36.1 35.0
70 1 88 100 54 53 129 6.2 4.88 245 77.8 171.1 101.5 30.4 26.6
57 0 68 142 74 66 172 8.4 4.55 262 93.3 150.6 112.3 40.1 41.1
78 0 72 146 72 65 70 5.6 4.10 247 68.5 160.3 96.6 29.5 26.7
21 0 64 98 46 47 70 10.4 4.44 274 56.7 159.4 83.4 29.2 22.3
74 1 60 128 66 62 124 5.5 4.21 228 70.5 176.8 81.3 32.2 22.6
58 0 94 128 72 54 106 10.2 4.60 280 138.9 162.5 144.2 46.6 52.6
69 1 80 156 84 98 118 6.9 3.90 251 90.6 178.7 103.7 34.3 28.4
49 0 72 122 88 51 113 5.4 4.36 333 72.8 147.9 95.7 34.4 33.3
45 0 56 118 78 58 83 7.8 4.05 245 60.8 164.4 81.0 27.6 22.5
56 1 86 124 84 48 193 8.2 4.68 286 116.2 170.4 126.0 38.7 40.0
24 1 72 112 72 43 52 6.4 5.32 262 75.2 174.3 89.6 34.2 24.8
39 1 74 122 80 48 143 6.4 5.32 268 81.3 177.2 98.0 33.5 25.9
49 1 92 128 70 31 99 9.1 4.65 320 91.4 174.4 110.8 35.3 30.1
74 1 58 158 56 63 64 5.2 3.60 103 79.1 177.1 104.0 31.0 25.2
46 0 80 114 68 68 84 5.7 4.14 329 83.6 166.1 99.9 33.2 30.3
37 0 76 112 68 48 126 9.3 3.39 298 89.9 169.1 95.3 37.7 31.4
44 1 64 134 84 43 102 8.5 3.64 203 89.1 178.4 105.0 32.6 28.0
42 0 56 106 72 51 96 7.9 4.24 203 105.1 149.5 131.0 40.2 47.0
53 1 68 136 82 39 149 6.6 5.03 206 116.0 179.1 125.5 39.3 36.2
19 1 64 94 58 34 61 4.9 4.57 240 74.7 165.3 80.7 33.2 27.3
56 0 56 118 80 47 86 8.8 5.03 196 101.8 162.8 110.0 37.0 38.4
80 1 62 146 68 41 83 7.4 4.37 206 104.8 162.0 130.8 35.3 39.9
19 1 64 106 64 55 52 5.9 4.84 172 64.9 178.7 78.7 28.6 20.3
29 0 54 106 64 69 92 4.1 3.64 176 84.5 165.1 97.0 34.7 31.0
26 1 64 120 66 34 115 7.4 5.28 206 79.0 180.1 88.9 32.2 24.4
40 1 58 106 72 29 64 5.3 4.95 199 74.2 174.4 90.7 31.7 24.4
30 1 66 118 64 54 107 8.6 4.91 252 66.9 169.0 86.9 30.3 23.4
43 0 72 144 98 57 57 3.3 4.85 331 75.3 164.0 95.0 32.9 28.0
22 0 70 130 68 67 87 5.6 4.16 209 64.5 165.2 80.5 28.2 23.6
42 1 58 120 64 41 43 7.1 5.08 310 90.7 174.4 104.4 35.2 29.8
21 0 80 116 72 56 80 8.9 4.43 227 52.6 162.9 74.0 26.0 19.8
20 0 72 106 62 40 128 7.6 5.14 262 92.5 163.1 104.7 34.7 34.8
30 1 72 122 78 55 186 6.9 5.51 198 82.6 173.2 101.3 30.7 27.5
45 0 62 112 68 94 119 6.8 4.13 257 62.2 163.3 82.7 28.7 23.3
75 1 60 150 86 43 76 6.8 4.45 198 103.6 185.1 115.0 36.5 30.2
20 0 96 122 68 66 68 5.3 4.35 281 62.1 162.9 72.1 26.5 23.4
29 1 62 122 76 44 153 6.7 5.15 192 88.4 174.8 95.0 40.3 28.9
55 0 72 114 74 54 155 6.4 4.61 233 71.7 166.1 96.0 31.1 26.0
45 0 60 102 60 61 124 4.7 4.59 223 75.6 173.2 87.4 30.8 25.2
68 1 82 166 94 46 153 9.4 4.84 254 94.5 172.0 111.7 32.5 31.9
57 1 82 134 96 50 176 6.9 5.02 282 92.2 174.4 111.6 32.3 30.3
56 1 72 126 74 57 127 8.7 4.73 393 56.8 182.8 74.5 26.2 17.0
37 0 98 126 68 72 158 6.3 4.49 258 125.7 169.8 128.3 42.0 43.6
42 1 62 118 80 49 127 6.1 5.53 294 100.4 179.4 102.9 38.9 31.2
39 1 76 116 74 63 142 5.3 4.28 228 103.7 180.3 108.3 36.4 31.9
23 0 72 106 54 38 73 6.1 4.47 221 56.7 156.1 94.0 27.5 23.3
23 0 80 110 56 61 113 7.3 4.48 184 61.7 168.0 81.2 27.3 21.9
20 0 84 112 70 36 50 9.1 4.10 322 108.3 163.0 122.2 41.9 40.8
24 1 78 114 56 46 124 7.0 4.86 284 61.0 178.2 75.5 27.6 19.2
27 1 78 126 78 42 192 8.5 5.25 285 104.4 181.1 109.4 37.7 31.8
60 0 68 102 68 48 157 5.6 3.97 262 56.5 147.2 91.8 29.0 26.1
52 1 84 120 74 38 125 11.3 4.66 219 96.2 172.2 114.1 37.0 32.4
80 1 74 122 50 31 71 5.6 3.45 233 98.7 169.8 124.2 37.2 34.2
61 0 86 114 74 53 166 6.0 4.61 210 101.3 176.1 111.6 34.6 32.7
33 1 72 130 76 43 150 5.3 4.89 229 115.3 193.3 116.9 36.3 30.9
51 1 60 112 82 61 173 5.1 4.49 166 67.4 159.9 86.8 31.1 26.4
80 1 70 126 66 57 50 6.2 3.72 161 58.4 164.5 86.6 25.2 21.6
30 1 66 130 82 63 77 8.6 4.29 238 83.2 183.6 86.2 32.3 24.7
76 0 72 130 76 56 147 5.0 3.89 232 60.1 153.3 92.6 29.1 25.6
43 1 82 116 74 37 75 5.9 4.69 251 84.8 165.4 109.7 34.8 31.0
70 0 80 160 40 38 79 5.1 4.26 250 90.5 165.4 106.8 35.3 33.1
75 0 64 144 72 48 115 5.4 4.65 206 60.4 161.9 93.8 26.6 23.0
22 0 82 118 56 42 102 9.3 4.49 239 84.5 166.9 100.8 34.2 30.3
30 1 80 138 82 42 163 8.2 4.93 305 96.2 170.1 117.0 33.5 33.2
21 1 54 120 54 58 105 7.3 4.82 300 65.3 175.7 78.4 27.0 21.2
46 0 80 108 68 64 127 6.3 4.20 255 57.7 155.6 86.7 29.7 23.8
46 0 62 114 80 63 118 4.0 4.64 303 69.6 168.6 91.8 31.8 24.5
74 0 74 106 64 91 132 5.8 4.18 274 67.3 177.3 85.2 26.4 21.4
45 1 80 140 84 43 101 5.9 4.44 239 72.6 162.8 93.7 31.3 27.4
34 0 96 120 74 37 69 10.8 3.78 395 133.3 171.1 144.0 37.5 45.5
53 1 76 142 98 26 202 9.3 5.47 290 90.3 173.7 113.8 34.7 29.9
48 1 70 120 68 77 116 4.2 4.23 178 89.2 169.4 103.9 34.8 31.1
51 1 54 108 68 49 143 6.1 5.18 212 84.8 181.9 95.0 33.5 25.6
29 1 72 114 68 71 127 4.0 5.01 140 65.3 171.4 78.0 31.0 22.2
33 1 68 112 70 48 137 5.7 4.44 258 100.2 190.3 101.1 35.3 27.7
80 1 68 112 46 53 87 5.5 3.99 138 75.5 161.9 107.5 30.1 28.8
48 1 80 102 56 30 89 9.9 4.40 189 79.1 183.6 97.4 30.8 23.5
64 0 72 108 64 64 97 4.6 4.43 181 67.8 163.1 90.9 31.0 25.5
80 0 96 142 66 84 123 6.1 4.24 306 55.4 144.2 88.5 28.6 26.6
18 1 76 106 50 52 65 6.6 5.39 208 54.1 168.7 67.4 25.5 19.0
33 1 62 104 68 53 118 3.2 4.77 183 96.8 187.2 92.1 40.3 27.6
51 0 64 134 56 53 48 6.5 4.35 231 70.5 156.3 101.1 31.7 28.9
18 1 72 106 44 40 124 4.0 5.17 221 71.6 172.8 78.1 31.0 24.0
49 0 62 164 96 77 126 5.5 4.98 190 78.4 163.4 90.0 33.0 29.4
67 1 62 136 82 39 62 7.7 3.90 305 110.2 169.1 125.5 39.0 38.5
18 0 82 100 72 52 70 7.2 4.07 236 71.4 162.5 86.2 34.2 27.0
42 0 76 130 64 62 60 8.0 4.00 132 62.0 175.6 74.5 26.1 20.1
24 1 94 96 62 43 102 7.0 5.29 260 56.3 162.7 78.4 27.9 21.3
50 0 94 132 84 42 69 7.9 4.35 244 103.2 146.7 142.6 39.5 48.0
53 1 86 132 74 42 112 8.4 4.07 75 102.6 181.0 117.7 36.5 31.3
34 0 74 104 54 44 103 7.6 4.36 292 96.1 162.2 109.0 37.0 36.5
31 1 90 104 70 64 112 6.0 5.07 197 56.4 165.4 74.0 26.5 20.6

Cigarette

Contents_Excel(1).xlsx

13 - Cigarette Contents

KING TAR KING NICOTINE KING CO MENTH TAR MENTH NICOTINE MENTH CO 100 TAR 100 NICOTINE 100 CO
20 1.1 16 16 1.1 15 5 0.4 4
27 1.7 16 13 0.8 17 16 1.0 19
27 1.7 16 16 1.0 19 17 1.2 17
20 1.1 16 9 0.9 9 13 0.8 18
20 1.1 16 14 0.8 17 13 0.8 18
24 1.4 17 13 0.8 17 14 1.0 13
20 1.1 16 12 0.8 15 15 1.1 17
23 1.4 15 14 0.8 17 15 1.1 15
20 1.0 16 14 0.9 15 15 1.1 15
22 1.2 14 13 0.8 17 9 0.8 12
20 1.1 16 13 0.8 17 13 0.8 18
20 1.1 16 16 1.2 15 13 0.8 17
20 1.1 16 13 0.8 17 13 0.8 18
20 1.1 16 13 0.8 17 15 1.0 16
20 1.1 16 18 1.3 18 2 0.2 3
10 1.8 14 9 0.7 11 15 1.1 18
24 1.6 16 19 1.4 18 15 1.0 15
20 1.1 16 2 0.2 3 13 0.8 18
21 1.2 14 13 0.8 17 14 1.0 15
25 1.5 18 14 1.0 14 15 0.9 17
23 1.3 15 14 0.8 15 16 1.1 15
20 1.1 16 15 0.8 22 15 1.1 15
22 1.3 14 16 1.2 16 7 0.6 7
20 1.1 16 6 0.6 7 17 1.3 16
20 1.1 16 8 0.7 9 15 1.1 14

Airport Data

Speeds_Excel(1).xlsx

32 - Airport Data Speeds

AIRPORT CODE VERIZON SPRINT AT&T T-MOBILE
RSW 38.5 13.0 9.7 8.6
ORD 55.6 30.4 8.2 7.0
SNA 22.4 15.2 7.1 18.5
MEM 14.1 2.4 14.4 16.7
MKE 23.1 2.7 13.4 5.6
IND 24.5 2.1 30.6 3.2
DCA 6.5 0.8 14.4 16.2
LAS 21.5 1.6 17.0 6.9
CMH 25.7 5.6 3.8 27.3
PIT 14.7 4.0 12.4 10.1
ATL 77.8 0.4 33.9 27.3
MDW 71.3 2.5 5.5 13.3
BWI 43.0 3.4 12.7 3.2
RDU 20.2 2.7 11.0 5.4
FLL 15.5 10.6 4.8 4.3
SMF 13.7 0.3 17.5 23.5
SEA 11.1 1.6 8.0 15.0
IAD 13.5 2.7 14.7 4.2
MCI 10.2 1.1 9.5 13.5
LGA 21.1 3.8 13.8 4.7
CLE 15.1 0.5 7.6 24.7
MCO 14.2 1.2 9.5 22.2
PDX 4.5 5.0 6.5 15.0
CLT 7.9 1.1 9.1 4.4
TPA 9.9 14.1 5.3 16.1
DFW 10.3 0.6 10.0 14.8
BOS 6.2 1.0 11.7 9.6
SJC 17.5 3.6 2.7 7.4
MIA 22.2 4.0 4.0 5.0
DTW 13.1 0.5 22.4 4.4
LAX 18.2 15.1 3.0 0.7
AUS 28.5 0.5 29.0 5.1
SLC 15.8 3.2 4.0 2.8
HNL 15.0 0.5 5.1 10.9
HOU 11.1 2.1 2.7 3.6
DEN 11.8 0.3 8.1 12.7
OAK 16.0 0.4 6.0 22.5
IAH 10.9 0.4 10.2 23.8
PHX 1.8 0.6 7.6 13.3
DAL 34.6 0.2 37.4 5.1
JFK 4.6 1.2 21.0 9.8
SFO 12.0 0.7 2.8 2.5
SAT 11.6 0.3 4.5 11.7
STL 3.6 8.2 2.2 17.3
BNA 1.9 2.3 4.6 9.5
MSY 7.7 0.3 6.3 1.4
PHL 0.8 0.5 7.5 5.9
EWR 4.5 9.6 9.3 13.4
MSP 1.4 0.3 10.0 16.7
SAN 3.2 0.3 2.7 2.6