Is the mean length of adult invasive Lionfish in the Atlantic coast of South Carolina greater than 355.6mm? (don't answer this, this is just so you know what the data is for) Answer the following questions and use the provided excel images, data on the far left is lionfish data Question 1. Describe your null and alternative hypotheses in words. Question 2. Describe your null and alternative hypotheses using symbols. Question 3. Select the significance level (a). Question 4. Select an appropriate test, calculate the test statistic and p-value using Excel. Test statistic: P-value: Question 5. Determine whether you should reject or not reject the null hypothesis based on the p-value. State the reason to support your answer. Question 6. Describe your conclusion in words in the context of your research question.
Is the mean length of adult invasive Lionfish in the Atlantic coast of South Carolina greater than 355.6mm? (don't answer this, this is just so you know what the data is for) Answer the following questions and use the provided excel images, data on the far left is lionfish data Question 1. Describe your null and alternative hypotheses in words. Question 2. Describe your null and alternative hypotheses using symbols. Question 3. Select the significance level (a). Question 4. Select an appropriate test, calculate the test statistic and p-value using Excel. Test statistic: P-value: Question 5. Determine whether you should reject or not reject the null hypothesis based on the p-value. State the reason to support your answer. Question 6. Describe your conclusion in words in the context of your research question.
Glencoe Algebra 1, Student Edition, 9780079039897, 0079039898, 2018
18th Edition
ISBN:9780079039897
Author:Carter
Publisher:Carter
Chapter10: Statistics
Section10.4: Distributions Of Data
Problem 22PFA
Related questions
Question
100%
![Is the mean length of adult invasive Lionfish in the Atlantic coast of South Carolina greater than
355.6mm? (don't answer this, this is just so you know what the data is for)
Answer the following questions and use the provided excel images, data on the far left is lionfish
data
Question 1. Describe your null and alternative hypotheses in words.
Question 2. Describe your null and alternative hypotheses using symbols.
Question 3. Select the significance level (a).
Question 4. Select an appropriate test, calculate the test statistic and p-value using Excel.
Test statistic:
P-value:
Question 5. Determine whether you should reject or not reject the null hypothesis based on the p-value.
State the reason to support your answer.
Question 6. Describe your conclusion in words in the context of your research question.](/v2/_next/image?url=https%3A%2F%2Fcontent.bartleby.com%2Fqna-images%2Fquestion%2F8dc28dc2-ec18-48e3-add3-d8ffcc65ab6b%2F803e0b24-19aa-4125-ade5-893817b26adf%2Fu8z6i7_processed.jpeg&w=3840&q=75)
Transcribed Image Text:Is the mean length of adult invasive Lionfish in the Atlantic coast of South Carolina greater than
355.6mm? (don't answer this, this is just so you know what the data is for)
Answer the following questions and use the provided excel images, data on the far left is lionfish
data
Question 1. Describe your null and alternative hypotheses in words.
Question 2. Describe your null and alternative hypotheses using symbols.
Question 3. Select the significance level (a).
Question 4. Select an appropriate test, calculate the test statistic and p-value using Excel.
Test statistic:
P-value:
Question 5. Determine whether you should reject or not reject the null hypothesis based on the p-value.
State the reason to support your answer.
Question 6. Describe your conclusion in words in the context of your research question.
![paste data
below
457.2
Use this sheet to perform a 1-sample t-test.
COUNT
20.00
431.9
MEAN
437.45
438.2
STANDARD DEVIATION
16.48
436.4
STANDARD ERROR
3.69
416.8
454.6
Confidence Interval
456.6
Level of Significance
95%
0.05
453.1
404.9
447.9
437.9
445.2
406.8
457.9
429.8
432.3
420.7
HYPOTHESIS TEST t-VALUE
t-critical (left tail)
t-critical (right tail)
HYPOTHESIS TEST RESULTS
proposed population mean
-2.093 Use this when Ha: sample mean <proposed population mean
2.093 Use this when Ha: sample mean > proposed population mean
t-statistic #VALUE!
p-value (left tail)[ #VALUE!
p-value (right tail) #VALUE!
<<<Input your proposed population parameter (mean) here.
Ha: sample mean <proposed population mean
Ha: sample mean > proposed population mean
431.8
457.2
431.8
paste
sample 1
data below
paste sample
2 data below
457.2
431.9
438.2
436.4
416.8
454.6
456.6
453.1
404.9
447.9
437.9
445.2
406.8
457.9
429.8
432.3
420.7
431.8
457.2
431.8
Use this sheet to perform a 2-sample t-test.
SAMPLE 1: COUNT
SAMPLE 1: MEAN
20.00
437.45
SAMPLE 2: COUNT
SAMPLE 2: MEAN
0.00
#DIV/0!
SAMPLE 1: STANDARD DEVIATION
SAMPLE 1: STANDARD ERROR
16.48
SAMPLE 2: STANDARD DEVIATION
#DIV/0!
3.69
SAMPLE 2: STANDARD ERROR
#DIV/0!
Confidence Interval
Level of Significance
HYPOTHESIS TEST RESULTS
t-statistic
p-value (2-tails)
95%
0.05
Note: Paste your data from the smaller sample into the sample 1 data column.
#DIV/0!
#DIV/0!](/v2/_next/image?url=https%3A%2F%2Fcontent.bartleby.com%2Fqna-images%2Fquestion%2F8dc28dc2-ec18-48e3-add3-d8ffcc65ab6b%2F803e0b24-19aa-4125-ade5-893817b26adf%2Fhlk1uyf_processed.jpeg&w=3840&q=75)
Transcribed Image Text:paste data
below
457.2
Use this sheet to perform a 1-sample t-test.
COUNT
20.00
431.9
MEAN
437.45
438.2
STANDARD DEVIATION
16.48
436.4
STANDARD ERROR
3.69
416.8
454.6
Confidence Interval
456.6
Level of Significance
95%
0.05
453.1
404.9
447.9
437.9
445.2
406.8
457.9
429.8
432.3
420.7
HYPOTHESIS TEST t-VALUE
t-critical (left tail)
t-critical (right tail)
HYPOTHESIS TEST RESULTS
proposed population mean
-2.093 Use this when Ha: sample mean <proposed population mean
2.093 Use this when Ha: sample mean > proposed population mean
t-statistic #VALUE!
p-value (left tail)[ #VALUE!
p-value (right tail) #VALUE!
<<<Input your proposed population parameter (mean) here.
Ha: sample mean <proposed population mean
Ha: sample mean > proposed population mean
431.8
457.2
431.8
paste
sample 1
data below
paste sample
2 data below
457.2
431.9
438.2
436.4
416.8
454.6
456.6
453.1
404.9
447.9
437.9
445.2
406.8
457.9
429.8
432.3
420.7
431.8
457.2
431.8
Use this sheet to perform a 2-sample t-test.
SAMPLE 1: COUNT
SAMPLE 1: MEAN
20.00
437.45
SAMPLE 2: COUNT
SAMPLE 2: MEAN
0.00
#DIV/0!
SAMPLE 1: STANDARD DEVIATION
SAMPLE 1: STANDARD ERROR
16.48
SAMPLE 2: STANDARD DEVIATION
#DIV/0!
3.69
SAMPLE 2: STANDARD ERROR
#DIV/0!
Confidence Interval
Level of Significance
HYPOTHESIS TEST RESULTS
t-statistic
p-value (2-tails)
95%
0.05
Note: Paste your data from the smaller sample into the sample 1 data column.
#DIV/0!
#DIV/0!
Expert Solution
![](/static/compass_v2/shared-icons/check-mark.png)
This question has been solved!
Explore an expertly crafted, step-by-step solution for a thorough understanding of key concepts.
This is a popular solution!
Trending now
This is a popular solution!
Step by step
Solved in 5 steps with 5 images
![Blurred answer](/static/compass_v2/solution-images/blurred-answer.jpg)
Recommended textbooks for you
![Glencoe Algebra 1, Student Edition, 9780079039897…](https://www.bartleby.com/isbn_cover_images/9780079039897/9780079039897_smallCoverImage.jpg)
Glencoe Algebra 1, Student Edition, 9780079039897…
Algebra
ISBN:
9780079039897
Author:
Carter
Publisher:
McGraw Hill
![Holt Mcdougal Larson Pre-algebra: Student Edition…](https://www.bartleby.com/isbn_cover_images/9780547587776/9780547587776_smallCoverImage.jpg)
Holt Mcdougal Larson Pre-algebra: Student Edition…
Algebra
ISBN:
9780547587776
Author:
HOLT MCDOUGAL
Publisher:
HOLT MCDOUGAL
![Big Ideas Math A Bridge To Success Algebra 1: Stu…](https://www.bartleby.com/isbn_cover_images/9781680331141/9781680331141_smallCoverImage.jpg)
Big Ideas Math A Bridge To Success Algebra 1: Stu…
Algebra
ISBN:
9781680331141
Author:
HOUGHTON MIFFLIN HARCOURT
Publisher:
Houghton Mifflin Harcourt
![Glencoe Algebra 1, Student Edition, 9780079039897…](https://www.bartleby.com/isbn_cover_images/9780079039897/9780079039897_smallCoverImage.jpg)
Glencoe Algebra 1, Student Edition, 9780079039897…
Algebra
ISBN:
9780079039897
Author:
Carter
Publisher:
McGraw Hill
![Holt Mcdougal Larson Pre-algebra: Student Edition…](https://www.bartleby.com/isbn_cover_images/9780547587776/9780547587776_smallCoverImage.jpg)
Holt Mcdougal Larson Pre-algebra: Student Edition…
Algebra
ISBN:
9780547587776
Author:
HOLT MCDOUGAL
Publisher:
HOLT MCDOUGAL
![Big Ideas Math A Bridge To Success Algebra 1: Stu…](https://www.bartleby.com/isbn_cover_images/9781680331141/9781680331141_smallCoverImage.jpg)
Big Ideas Math A Bridge To Success Algebra 1: Stu…
Algebra
ISBN:
9781680331141
Author:
HOUGHTON MIFFLIN HARCOURT
Publisher:
Houghton Mifflin Harcourt