Question: Use the data by Excel to find : SPSS Analysis 2. results of the T-test: Report the t-statistic, degrees of freedom, and p-value. 3. Conclusion
Use the data by Excel to find :
- SPSS Analysis
2. results of the T-test: Report the t-statistic, degrees of freedom, and p-value.
3. Conclusion Summarize the findings: If the null hypothesis is rejected, state that there is a significant difference in height between males and females. If not rejected, indicate that there is insufficient evidence to claim a significant difference.
4. Limitations Acknowledge any limitations in the analysis, such as sample size, data collection methods, or potential biases.
DATA :
| hgtmm | hgtin | gender |
| 1720 | 67.72 | f |
| 1560 | 61.42 | f |
| 1580 | 62.2 | f |
| 1650 | 64.96 | f |
| 1610 | 63.39 | f |
| 1700 | 66.93 | f |
| 1690 | 66.54 | f |
| 1650 | 64.96 | f |
| 1620 | 63.78 | f |
| 1630 | 64.17 | f |
| 1590 | 62.6 | f |
| 1560 | 61.42 | f |
| 1620 | 63.78 | f |
| 1540 | 60.63 | f |
| 1420 | 55.91 | f |
| 1660 | 65.35 | f |
| 1610 | 63.39 | f |
| 1635 | 64.37 | f |
| 1580 | 62.2 | f |
| 1610 | 63.39 | f |
| 1590 | 62.6 | f |
| 1610 | 63.39 | f |
| 1700 | 66.93 | f |
| 1522 | 59.92 | f |
| 1680 | 66.14 | f |
| 1680 | 66.14 | f |
| 1630 | 64.17 | f |
| 1570 | 61.81 | f |
| 1740 | 68.5 | f |
| 1600 | 62.99 | f |
| 1689 | 66.5 | f |
| 1600 | 62.99 | f |
| 1550 | 61.02 | f |
| 1540 | 60.63 | f |
| 1640 | 64.57 | f |
| 1640 | 64.57 | f |
| 1630 | 64.17 | f |
| 1560 | 61.42 | f |
| 1652 | 65.04 | f |
| 1580 | 62.2 | f |
| 1570 | 61.81 | f |
| 1590 | 62.6 | f |
| 1650 | 64.96 | f |
| 1591 | 62.64 | f |
| 1670 | 65.75 | f |
| 1600 | 62.99 | f |
| 1610 | 63.39 | f |
| 1610 | 63.39 | f |
| 1670 | 65.75 | f |
| 1510 | 59.45 | f |
| 1520 | 59.84 | f |
| 1620 | 63.78 | f |
| 1530 | 60.24 | f |
| 1451 | 57.13 | f |
| 1570 | 61.81 | f |
| 1580 | 62.2 | f |
| 1590 | 62.6 | f |
| 1670 | 65.75 | f |
| 1630 | 64.17 | f |
| 1510 | 59.45 | f |
| 1560 | 61.42 | f |
| 1660 | 65.35 | f |
| 1610 | 63.39 | f |
| 1570 | 61.81 | f |
| 1670 | 65.75 | f |
| 1635 | 64.37 | f |
| 1670 | 65.75 | f |
| 1730 | 68.11 | f |
| 1590 | 62.6 | f |
| 1600 | 62.99 | f |
| 1490 | 58.66 | f |
| 1660 | 65.35 | f |
| 1504 | 59.21 | f |
| 1500 | 59.06 | f |
| 1640 | 64.57 | f |
| 1650 | 64.96 | f |
| 1620 | 63.78 | f |
| 1550 | 61.02 | f |
| 1640 | 64.57 | f |
| 1560 | 61.42 | f |
| 1552 | 61.1 | f |
| 1600 | 62.99 | f |
| 1545 | 60.83 | f |
| 1570 | 61.81 | f |
| 1550 | 61.02 | f |
| 1600 | 62.99 | f |
| 1660 | 65.35 | f |
| 1640 | 64.57 | f |
| 1670 | 65.75 | f |
| 1560 | 61.42 | f |
| 1760 | 69.29 | f |
| 1550 | 61.02 | f |
| 1640 | 64.57 | f |
| 1600 | 62.99 | f |
| 1571 | 61.85 | f |
| 1550 | 61.02 | f |
| 1570 | 61.81 | f |
| 1590 | 62.6 | f |
| 1690 | 66.54 | f |
| 1580 | 62.2 | f |
| 1590 | 62.6 | f |
| 1510 | 59.45 | f |
| 1600 | 62.99 | f |
| 1660 | 65.35 | f |
| 1700 | 66.93 | f |
| 1530 | 60.24 | f |
| 1490 | 58.66 | f |
| 1580 | 62.2 | f |
| 1500 | 59.06 | f |
| 1600 | 62.99 | f |
| 1570 | 61.81 | f |
| 1620 | 63.78 | f |
| 1410 | 55.51 | f |
| 1560 | 61.42 | f |
| 1590 | 62.6 | f |
| 1710 | 67.32 | f |
| 1580 | 62.2 | f |
| 1690 | 66.54 | f |
| 1610 | 63.39 | f |
| 1660 | 65.35 | f |
| 1590 | 62.6 | f |
| 1530 | 60.24 | f |
| 1690 | 66.54 | f |
| 1600 | 62.99 | f |
| 1693 | 66.65 | f |
| 1580 | 62.2 | f |
| 1636 | 64.41 | f |
| 1670 | 65.75 | f |
| 1600 | 62.99 | f |
| 1570 | 61.81 | f |
| 1740 | 68.5 | f |
| 1540 | 60.63 | f |
| 1555 | 61.22 | f |
| 1614 | 63.54 | f |
| 1530 | 60.24 | f |
| 1590 | 62.6 | f |
| 1610 | 63.39 | f |
| 1670 | 65.75 | f |
| 1690 | 66.54 | f |
| 1550 | 61.02 | f |
| 1650 | 64.96 | f |
| 1540 | 60.63 | f |
| 1660 | 65.35 | f |
| 1620 | 63.78 | f |
| 1630 | 64.17 | f |
| 1610 | 63.39 | f |
| 1540 | 60.63 | f |
| 1610 | 63.39 | f |
| 1630 | 64.17 | f |
| 1530 | 60.24 | f |
| 1520 | 59.84 | f |
| 1544 | 60.79 | f |
| 1570 | 61.81 | f |
| 1580 | 62.2 | f |
| 1550 | 61.02 | f |
| 1570 | 61.81 | f |
| 1521 | 59.88 | f |
| 1580 | 62.2 | f |
| 1630 | 64.17 | f |
| 1640 | 64.57 | f |
| 1650 | 64.96 | f |
| 1520 | 59.84 | f |
| 1620 | 63.78 | f |
| 1744 | 68.66 | f |
| 1647 | 64.84 | f |
| 1615 | 63.58 | f |
| 1680 | 66.14 | f |
| 1670 | 65.75 | f |
| 1620 | 63.78 | f |
| 1570 | 61.81 | f |
| 1660 | 65.35 | f |
| 1550 | 61.02 | f |
| 1590 | 62.6 | f |
| 1560 | 61.42 | f |
| 1670 | 65.75 | f |
| 1650 | 64.96 | f |
| 1539 | 60.59 | f |
| 1470 | 57.87 | f |
| 1580 | 62.2 | f |
| 1670 | 65.75 | f |
| 1520 | 59.84 | f |
| 1620 | 63.78 | f |
| 1710 | 67.32 | f |
| 1530 | 60.24 | f |
| 1720 | 67.72 | f |
| 1570 | 61.81 | f |
| 1560 | 61.42 | f |
| 1650 | 64.96 | f |
| 1635 | 64.37 | f |
| 1590 | 62.6 | f |
| 1590 | 62.6 | f |
| 1566 | 61.65 | f |
| 1590 | 62.6 | f |
| 1662 | 65.43 | f |
| 1550 | 61.02 | f |
| 1570 | 61.81 | f |
| 1560 | 61.42 | f |
| 1630 | 64.17 | f |
| 1530 | 60.24 | f |
| 1809 | 71.22 | m |
| 1841 | 72.48 | m |
| 1659 | 65.31 | m |
| 1779 | 70.04 | m |
| 1616 | 63.62 | m |
| 1695 | 66.73 | m |
| 1730 | 68.11 | m |
| 1753 | 69.02 | m |
| 1740 | 68.5 | m |
| 1685 | 66.34 | m |
| 1735 | 68.31 | m |
| 1713 | 67.44 | m |
| 1736 | 68.35 | m |
| 1715 | 67.52 | m |
| 1799 | 70.83 | m |
| 1785 | 70.28 | m |
| 1758 | 69.21 | m |
| 1729 | 68.07 | m |
| 1720 | 67.72 | m |
| 1810 | 71.26 | m |
| 1725 | 67.91 | m |
| 1764 | 69.45 | m |
| 1683 | 66.26 | m |
| 1585 | 62.4 | m |
| 1684 | 66.3 | m |
| 1674 | 65.91 | m |
| 1724 | 67.87 | m |
| 1630 | 64.17 | m |
| 1855 | 73.03 | m |
| 1796 | 70.71 | m |
| 1700 | 66.93 | m |
| 1765 | 69.49 | m |
| 1700 | 66.93 | m |
| 1721 | 67.76 | m |
| 1829 | 72.01 | m |
| 1710 | 67.32 | m |
| 1745 | 68.7 | m |
| 1698 | 66.85 | m |
| 1853 | 72.95 | m |
| 1610 | 63.39 | m |
| 1680 | 66.14 | m |
| 1809 | 71.22 | m |
| 1580 | 62.2 | m |
| 1600 | 62.99 | m |
| 1585 | 62.4 | m |
| 1705 | 67.13 | m |
| 1675 | 65.94 | m |
| 1735 | 68.31 | m |
| 1686 | 66.38 | m |
| 1768 | 69.61 | m |
| 1721 | 67.76 | m |
| 1754 | 69.06 | m |
| 1739 | 68.46 | m |
| 1699 | 66.89 | m |
| 1825 | 71.85 | m |
| 1740 | 68.5 | m |
| 1704 | 67.09 | m |
| 1719 | 67.68 | m |
| 1731 | 68.15 | m |
| 1679 | 66.1 | m |
| 1755 | 69.09 | m |
| 1713 | 67.44 | m |
| 1723 | 67.83 | m |
| 1783 | 70.2 | m |
| 1585 | 62.4 | m |
| 1749 | 68.86 | m |
| 1710 | 67.32 | m |
| 1724 | 67.87 | m |
| 1620 | 63.78 | m |
| 1764 | 69.45 | m |
| 1791 | 70.51 | m |
| 1795 | 70.67 | m |
| 1738 | 68.43 | m |
| 1639 | 64.53 | m |
| 1734 | 68.27 | m |
| 1695 | 66.73 | m |
| 1666 | 65.59 | m |
| 1745 | 68.7 | m |
| 1775 | 69.88 | m |
| 1669 | 65.71 | m |
| 1700 | 66.93 | m |
| 1804 | 71.02 | m |
| 1700 | 66.93 | m |
| 1664 | 65.51 | m |
| 1750 | 68.9 | m |
| 1753 | 69.02 | m |
| 1788 | 70.39 | m |
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
