
MATLAB: An Introduction with Applications
6th Edition
ISBN: 9781119256830
Author: Amos Gilat
Publisher: John Wiley & Sons Inc
expand_more
expand_more
format_list_bulleted
Question
![### Construct and Understand Frequency Tables for a Set of Data with Technology - Excel
#### Question
Sheri writes down the amount of time in minutes that it takes for her to commute to work each day for 20 consecutive days. The results are given below.
**Commute Times (in minutes):**
| | | | | |
|---|---|---|---|---|
| 30 | 29 | 28 | 32 | |
| 33 | 28 | 35 | 33 | 29 |
| 30 | 34 | 40 | 30 | 32 |
| 31 | | 29 | 28 | 33 |
| | | | 30 | |
**Instructions:**
Use Excel to create a frequency table for the data. What is the longest commute time with a frequency greater than 1?
**Provide your answer below:**
\[ \text{Input Box} \]
[end of explanation text for input box]
[Options for interface]
- \[ Help \]
- \[ Copy to Clipboard \]
- \[ Download CSV \]
### Explanation for Creating a Frequency Table in Excel:
1. **Input Data:**
- Enter the commute times into a single column in an Excel spreadsheet.
2. **Creating the Frequency Table:**
- Select the range of data entered.
- Use the function `=FREQUENCY(data_array, bins_array)` to calculate the frequency.
- Create bins at even intervals (or use unique values) that cover the range of commute times in your data.
3. **Identify the Longest Commute Time with Frequency Greater Than 1:**
- Review the frequency table.
- Note the commute times and their corresponding frequencies.
- Identify the maximum commute time that has a frequency greater than 1.
This exercise will help in understanding how to organize and summarize data efficiently using Excel's tools.](https://content.bartleby.com/qna-images/question/9a513490-f6c0-46f0-b28d-50ae7b5a1f99/13c6c94d-4161-4cfd-bcee-39091ab4b54c/hqbuhh_thumbnail.jpeg)
Transcribed Image Text:### Construct and Understand Frequency Tables for a Set of Data with Technology - Excel
#### Question
Sheri writes down the amount of time in minutes that it takes for her to commute to work each day for 20 consecutive days. The results are given below.
**Commute Times (in minutes):**
| | | | | |
|---|---|---|---|---|
| 30 | 29 | 28 | 32 | |
| 33 | 28 | 35 | 33 | 29 |
| 30 | 34 | 40 | 30 | 32 |
| 31 | | 29 | 28 | 33 |
| | | | 30 | |
**Instructions:**
Use Excel to create a frequency table for the data. What is the longest commute time with a frequency greater than 1?
**Provide your answer below:**
\[ \text{Input Box} \]
[end of explanation text for input box]
[Options for interface]
- \[ Help \]
- \[ Copy to Clipboard \]
- \[ Download CSV \]
### Explanation for Creating a Frequency Table in Excel:
1. **Input Data:**
- Enter the commute times into a single column in an Excel spreadsheet.
2. **Creating the Frequency Table:**
- Select the range of data entered.
- Use the function `=FREQUENCY(data_array, bins_array)` to calculate the frequency.
- Create bins at even intervals (or use unique values) that cover the range of commute times in your data.
3. **Identify the Longest Commute Time with Frequency Greater Than 1:**
- Review the frequency table.
- Note the commute times and their corresponding frequencies.
- Identify the maximum commute time that has a frequency greater than 1.
This exercise will help in understanding how to organize and summarize data efficiently using Excel's tools.
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 nowThis is a popular solution!
Step by stepSolved in 3 steps with 3 images

Knowledge 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.Similar questions
- State whether the variable is discrete or continuous: The number of books in your school's library.arrow_forwardWhich kind of function is called the greatest integer function?arrow_forwardDetermine whether the statement makes sense or does not make sense, and explain your reasoning : "My body temperature is a function of the time of day."arrow_forward
- Construct the FDT of Salary using your own data and list the range of your classes with their corresponding Absolute Frequencies.arrow_forwardThe graphs show the various temperatures for the month of January in 2 cities. Which city has a higher variability of their January temperature?arrow_forwardBelow is the table of values of a function. Write the output when the input is n. input 3 5 9 E output 3 7arrow_forward
arrow_back_ios
arrow_forward_ios
Recommended textbooks for you
- MATLAB: An Introduction with ApplicationsStatisticsISBN:9781119256830Author:Amos GilatPublisher:John Wiley & Sons IncProbability and Statistics for Engineering and th...StatisticsISBN:9781305251809Author:Jay L. DevorePublisher:Cengage LearningStatistics for The Behavioral Sciences (MindTap C...StatisticsISBN:9781305504912Author:Frederick J Gravetter, Larry B. WallnauPublisher:Cengage Learning
- Elementary Statistics: Picturing the World (7th E...StatisticsISBN:9780134683416Author:Ron Larson, Betsy FarberPublisher:PEARSONThe Basic Practice of StatisticsStatisticsISBN:9781319042578Author:David S. Moore, William I. Notz, Michael A. FlignerPublisher:W. H. FreemanIntroduction to the Practice of StatisticsStatisticsISBN:9781319013387Author:David S. Moore, George P. McCabe, Bruce A. CraigPublisher:W. H. Freeman

MATLAB: An Introduction with Applications
Statistics
ISBN:9781119256830
Author:Amos Gilat
Publisher:John Wiley & Sons Inc

Probability and Statistics for Engineering and th...
Statistics
ISBN:9781305251809
Author:Jay L. Devore
Publisher:Cengage Learning

Statistics for The Behavioral Sciences (MindTap C...
Statistics
ISBN:9781305504912
Author:Frederick J Gravetter, Larry B. Wallnau
Publisher:Cengage Learning

Elementary Statistics: Picturing the World (7th E...
Statistics
ISBN:9780134683416
Author:Ron Larson, Betsy Farber
Publisher:PEARSON

The Basic Practice of Statistics
Statistics
ISBN:9781319042578
Author:David S. Moore, William I. Notz, Michael A. Fligner
Publisher:W. H. Freeman

Introduction to the Practice of Statistics
Statistics
ISBN:9781319013387
Author:David S. Moore, George P. McCabe, Bruce A. Craig
Publisher:W. H. Freeman