Question

In: Statistics and Probability

The excel data are flash durations, in milliseconds, of a sample of 35 male fireflies of...

The excel data are flash durations, in milliseconds, of a sample of 35 male fireflies of the species Photinus(Cratsley and Lewis 2003). You must use excel tools data analysis and descriptive statistics to find the confidence interval. Use the video as a guide to complete this excel project. If you do not see the data analysis, I have steps on how to get the data analysis tool on this document.

  1. Estimate the sample mean flash duration. What does this quantity estimate?
  2. Is the estimate in part(a) likely to equal the population parameter? Why or why not?
  3. Paste the descriptive statistics output from excel
  4. Use the descriptive statistics output to record the standard error for your estimate.
  5. What does the quantity in part(d) measure?
  6. Use excel output to calculate the 95% confidence interval for the population mean.
  7. Provide an interpretation for the interval you calculated in part(f)

PLEASE SHOW ALL WORK WHEN POSSIBLE!

Data:

94
96
95
95
95
96
98
98
98
101
103
106
108
109
112
113
118
116
119

Solutions

Expert Solution

orchestra answered 1 year ago
Next > < Previous

Related Solutions

The excel data are flash durations, in milliseconds, of a sample of 35 male fireflies of...
The excel data are flash durations, in milliseconds, of a sample of 35 male fireflies of the species Photinus(Cratsley and Lewis 2003). You must use excel tools data analysis and descriptive statistics to find the confidence interval. Use the video as a guide to complete this excel project. If you do not see the data analysis, I have steps on how to get the data analysis tool on this document. Estimate the sample mean flash duration. What does this quantity...
Sample A is from a 35 year old male who visited his GP complaining of chest...
Sample A is from a 35 year old male who visited his GP complaining of chest pain during exercise. An ECG taken at rest was normal but ischaemic changes developed on exercise. A family history revealed that his father died of a heart attack at the age of 45 years. The laboratory test results for his fasting blood sample were as follows: Analyte                       Patient values                        Reference range for fasting      blood sample Sodium                                    139                              135-145 mmol/L Potassium                                4.1                               3.0-5.0...
Sample A is from a 35 year old male who visited his GP complaining of chest...
Sample A is from a 35 year old male who visited his GP complaining of chest pain during exercise. An ECG taken at rest was normal but ischaemic changes developed on exercise. A family history revealed that his father died of a heart attack at the age of 45 years. The laboratory test results for his fasting blood sample were as follows: Analyte                       Patient values                        Reference range for fasting      blood sample Sodium                                    139                              135-145 mmol/L Potassium                                4.1                               3.0-5.0...
Sample A is from a 35 year old male who visited his GP complaining of chest...
Sample A is from a 35 year old male who visited his GP complaining of chest pain during exercise. An ECG taken at rest was normal but ischaemic changes developed on exercise. A family history revealed that his father died of a heart attack at the age of 45 years. The laboratory test results for his fasting blood sample were as follows: Analyte                       Patient values                        Reference range for fasting      blood sample Sodium                                    139                              135-145 mmol/L Potassium                                4.1                               3.0-5.0...
Sample A is from a 35 year old male who visited his GP complaining of chest...
Sample A is from a 35 year old male who visited his GP complaining of chest pain during exercise. An ECG taken at rest was normal but ischaemic changes developed on exercise. A family history revealed that his father died of a heart attack at the age of 45 years. The laboratory test results for his fasting blood sample were as follows: Analyte                       Patient values                        Reference range for fasting      blood sample Sodium                                    139                              135-145 mmol/L Potassium                                4.1                               3.0-5.0...
Sample A is from a 35 year old male who visited his GP complaining of chest...
Sample A is from a 35 year old male who visited his GP complaining of chest pain during exercise. An ECG taken at rest was normal but ischaemic changes developed on exercise. A family history revealed that his father died of a heart attack at the age of 45 years. The laboratory test results for his fasting blood sample were as follows: Analyte                       Patient values                        Reference range for fasting      blood sample Sodium                                    139                              135-145 mmol/L Potassium                                4.1                               3.0-5.0...
Case Study 1 Sample A is from a 35 year old male who visited his GP...
Case Study 1 Sample A is from a 35 year old male who visited his GP complaining of chest pain during exercise. An ECG taken at rest was normal but ischaemic changes developed on exercise. A family history revealed that his father died of a heart attack at the age of 45 years. The laboratory test results for his fasting blood sample were as follows: Analyte                       Patient values                        Reference range for fasting      blood sample Sodium                                    139                              135-145 mmol/L Potassium                               ...
Listed below are the durations​ (in hours) of a simple random sample of all flights of...
Listed below are the durations​ (in hours) of a simple random sample of all flights of a space shuttle program. Find the​ range, variance, and standard deviation for the sample data. Is the lowest duration time​ unusual? Why or why​ not? 76    90    234    195    165    265    197    372    252    237    384    340    225    245    0
National data indicates that​ 35% of households own a desktop computer. In a random sample of...
National data indicates that​ 35% of households own a desktop computer. In a random sample of 570​ households, 40% owned a desktop computer. Does this provide enough evidence to show a difference in the proportion of households that own a​ desktop? Identify the appropriate null and alternative hypotheses. A. H0: p= 0.35 Ha​: p ≠ 0.35 B. H0​: p​ = 0.40     Ha​:p​ > 0.40 C. H0​:p​ = 0.35     Ha​:p​ < 0.35 D. H0​:p​ = 0.40     Ha​:p ≠ 0.40
2. The following data on distilled alcohol content (%) for a sample of 35 port wines...
2. The following data on distilled alcohol content (%) for a sample of 35 port wines was extracted from the article “A Method for the Estimation of Alcohol in Fortified Wines Using Hydrometer Baumé and Refractometer Brix” (Amer. J. Enol. Vitic., 2006: 486–490). Each value is an average of two duplicate measurements. 16.35 18.85 16.20 17.75 19.58 17.73 22.75 23.78 9.12 10.22 23.25 19.08 19.62 33.05 19.20 20.05 17.85 19.17 19.48 20.00 19.97 42.13 11.42 03.28 41.56 17.48 17.15 19.07...
ADVERTISEMENT
Subjects
ADVERTISEMENT
Latest Questions
ADVERTISEMENT