Employees in the marketing department of a large regional restaurant chain are researching the amount of money that households in the region spend in restaurants per year. The employees are looking at how the amount spent annually in restaurants by households led by people ages 25 to 34 compares to households led by people ages 45 to 54. To conduct the research, the employees randomly select 100 households in the region led by people ages 25 to 34 and 100 households in the region led by people ages 45 to 54. Each household is asked how much was spent in restaurants during the previous 12 months. The amounts spent for each household, in dollars, are provided in the samples below. One household in each group spent $1,924 in restaurants during the previous 12 months. Use Excel to calculate the z-score for the data value that represents the household that spent $1,924 in restaurants for each group. Round your answers to two decimal places. Provide your answer below: 25 to 34 45 to 54 1458 2186 1548 1705 1533 2221 1258 1676 1203 2099 1323 1826 1880 2423 1563 2236 1924 1692 1838 1890 1359 1671 1630 2314 1606 2267 1520 2446 1741 2217 1547 2367 1283 1948 1527 1652 1655 1926 1378 2330 1630 1686 1350 2443 1373 1998 1318 2244 1827 2373 1737 1891 1815 1909 1394 1898 1376 2351 1712 2405 1639 2094 1412 1694 1383 2406 1848 1929 1330 1841 1924 1848 1245 1913 1727 1954 1324 2144 1389 1882 1806 2370 1731 1865 1587 1974 1331 1668 1646 1878 1830 1957 1559 2343 1349 2423 1401 2212 1569 2138 1282 2145 1345 2157 1234 1915 1736 1654 1296 1652 1740 1904 1587 2020 1838 1684 1225 2390 1537 2250 1636 2338 1297 2062 1911 1865 1645 2332 1338 1675 1227 1908 1715 2383 1377 2292 1286 2299 1630 2221 1462 1945 1375 2161 1438 2377 1508 1890 1722 1978 1350 1698 1752 2147 1340 2167 1354 2046 1733 2013 1880 2348 1719 2114 1349 1668 1719 2020 1350 2219 1873 2240 1534 1634 1802 2401 1653 1933 1741 2035 1260 2433 1350 2069 1485 2003 1553 1956 1590 1924 1363 1675 1407 2071 1548 1892 1783 2149 1719 1995 The $z$ -score for the household led by people ages 25 to 34 is and the $z$ -score for the household led by people ages 45 to 54 is
Employees in the marketing department of a large regional restaurant chain are researching the amount of money that households in the region spend in restaurants per year. The employees are looking at how the amount spent annually in restaurants by households led by people ages 25 to 34 compares to households led by people ages 45 to 54. To conduct the research, the employees randomly select 100 households in the region led by people ages 25 to 34 and 100 households in the region led by people ages 45 to 54. Each household is asked how much was spent in restaurants during the previous 12 months. The amounts spent for each household, in dollars, are provided in the samples below. One household in each group spent $1,924 in restaurants during the previous 12 months. Use Excel to calculate the z-score for the data value that represents the household that spent $1,924 in restaurants for each group. Round your answers to two decimal places. Provide your answer below: 25 to 34 45 to 54 1458 2186 1548 1705 1533 2221 1258 1676 1203 2099 1323 1826 1880 2423 1563 2236 1924 1692 1838 1890 1359 1671 1630 2314 1606 2267 1520 2446 1741 2217 1547 2367 1283 1948 1527 1652 1655 1926 1378 2330 1630 1686 1350 2443 1373 1998 1318 2244 1827 2373 1737 1891 1815 1909 1394 1898 1376 2351 1712 2405 1639 2094 1412 1694 1383 2406 1848 1929 1330 1841 1924 1848 1245 1913 1727 1954 1324 2144 1389 1882 1806 2370 1731 1865 1587 1974 1331 1668 1646 1878 1830 1957 1559 2343 1349 2423 1401 2212 1569 2138 1282 2145 1345 2157 1234 1915 1736 1654 1296 1652 1740 1904 1587 2020 1838 1684 1225 2390 1537 2250 1636 2338 1297 2062 1911 1865 1645 2332 1338 1675 1227 1908 1715 2383 1377 2292 1286 2299 1630 2221 1462 1945 1375 2161 1438 2377 1508 1890 1722 1978 1350 1698 1752 2147 1340 2167 1354 2046 1733 2013 1880 2348 1719 2114 1349 1668 1719 2020 1350 2219 1873 2240 1534 1634 1802 2401 1653 1933 1741 2035 1260 2433 1350 2069 1485 2003 1553 1956 1590 1924 1363 1675 1407 2071 1548 1892 1783 2149 1719 1995 The $z$ -score for the household led by people ages 25 to 34 is and the $z$ -score for the household led by people ages 45 to 54 is
Glencoe Algebra 1, Student Edition, 9780079039897, 0079039898, 2018
18th Edition
ISBN:9780079039897
Author:Carter
Publisher:Carter
Chapter10: Statistics
Section10.6: Summarizing Categorical Data
Problem 10CYU
Related questions
Topic Video
Question
100%
Employees in the marketing department of a large regional restaurant chain are researching the amount of money that households in the region spend in restaurants per year. The employees are looking at how the amount spent annually in restaurants by households led by people ages 25 to 34 compares to households led by people ages 45 to 54. To conduct the research, the employees randomly select 100 households in the region led by people ages 25 to 34 and 100 households in the region led by people ages 45 to 54. Each household is asked how much was spent in restaurants during the previous 12 months. The amounts spent for each household, in dollars, are provided in the samples below. One household in each group spent $1,924 in restaurants during the previous 12 months. Use Excel to calculate the z-score for the data value that represents the household that spent $1,924 in restaurants for each group. Round your answers to two decimal places. Provide your answer below:
| 25 to 34 | 45 to 54 |
| 1458 | 2186 |
| 1548 | 1705 |
| 1533 | 2221 |
| 1258 | 1676 |
| 1203 | 2099 |
| 1323 | 1826 |
| 1880 | 2423 |
| 1563 | 2236 |
| 1924 | 1692 |
| 1838 | 1890 |
| 1359 | 1671 |
| 1630 | 2314 |
| 1606 | 2267 |
| 1520 | 2446 |
| 1741 | 2217 |
| 1547 | 2367 |
| 1283 | 1948 |
| 1527 | 1652 |
| 1655 | 1926 |
| 1378 | 2330 |
| 1630 | 1686 |
| 1350 | 2443 |
| 1373 | 1998 |
| 1318 | 2244 |
| 1827 | 2373 |
| 1737 | 1891 |
| 1815 | 1909 |
| 1394 | 1898 |
| 1376 | 2351 |
| 1712 | 2405 |
| 1639 | 2094 |
| 1412 | 1694 |
| 1383 | 2406 |
| 1848 | 1929 |
| 1330 | 1841 |
| 1924 | 1848 |
| 1245 | 1913 |
| 1727 | 1954 |
| 1324 | 2144 |
| 1389 | 1882 |
| 1806 | 2370 |
| 1731 | 1865 |
| 1587 | 1974 |
| 1331 | 1668 |
| 1646 | 1878 |
| 1830 | 1957 |
| 1559 | 2343 |
| 1349 | 2423 |
| 1401 | 2212 |
| 1569 | 2138 |
| 1282 | 2145 |
| 1345 | 2157 |
| 1234 | 1915 |
| 1736 | 1654 |
| 1296 | 1652 |
| 1740 | 1904 |
| 1587 | 2020 |
| 1838 | 1684 |
| 1225 | 2390 |
| 1537 | 2250 |
| 1636 | 2338 |
| 1297 | 2062 |
| 1911 | 1865 |
| 1645 | 2332 |
| 1338 | 1675 |
| 1227 | 1908 |
| 1715 | 2383 |
| 1377 | 2292 |
| 1286 | 2299 |
| 1630 | 2221 |
| 1462 | 1945 |
| 1375 | 2161 |
| 1438 | 2377 |
| 1508 | 1890 |
| 1722 | 1978 |
| 1350 | 1698 |
| 1752 | 2147 |
| 1340 | 2167 |
| 1354 | 2046 |
| 1733 | 2013 |
| 1880 | 2348 |
| 1719 | 2114 |
| 1349 | 1668 |
| 1719 | 2020 |
| 1350 | 2219 |
| 1873 | 2240 |
| 1534 | 1634 |
| 1802 | 2401 |
| 1653 | 1933 |
| 1741 | 2035 |
| 1260 | 2433 |
| 1350 | 2069 |
| 1485 | 2003 |
| 1553 | 1956 |
| 1590 | 1924 |
| 1363 | 1675 |
| 1407 | 2071 |
| 1548 | 1892 |
| 1783 | 2149 |
| 1719 | 1995 |
The $z$ -score for the household led by people ages 25 to 34 is and the $z$ -score for the household led by people ages 45 to 54 is
Expert Solution
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 2 steps with 3 images
Follow-up Questions
Read through expert solutions to related follow-up questions below.
Follow-up Question
based on the z scores would a 25 to 34 household or a 45 to 54 household be more likely to spend $1,924
Solution
by Bartleby ExpertKnowledge Booster
Learn more about
Need a deep-dive on the concept behind this application? Look no further. Learn more about this topic, statistics and related others by exploring similar questions and additional content below.Recommended textbooks for you
Glencoe Algebra 1, Student Edition, 9780079039897…
Algebra
ISBN:
9780079039897
Author:
Carter
Publisher:
McGraw Hill
Holt Mcdougal Larson Pre-algebra: Student Edition…
Algebra
ISBN:
9780547587776
Author:
HOLT MCDOUGAL
Publisher:
HOLT MCDOUGAL
Glencoe Algebra 1, Student Edition, 9780079039897…
Algebra
ISBN:
9780079039897
Author:
Carter
Publisher:
McGraw Hill
Holt Mcdougal Larson Pre-algebra: Student Edition…
Algebra
ISBN:
9780547587776
Author:
HOLT MCDOUGAL
Publisher:
HOLT MCDOUGAL