
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
Whats the step by step process in excel for getting the frequency distribution and percentage frequency distribution?
Data is is follows:

Expert Solution

arrow_forward
Step 1
Excel procedure for frequency distribution:
- Type your data into a worksheet
- Sort the data in ascending order.
- Type the upper levels for your BINs into a separate column.
- Make a column of labels
- Decide on the number of intervals in the frequency distribution.
- Tally and count the observations under each interval.
- Click the “Data” tab
- Click “Histogram” and then click “OK.”
Step by stepSolved in 2 steps

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
- I need helparrow_forwardPlease do not give solution in image format thanku A car salesman collected data on how many cars were sold at a dealership per day for two weeks. The results were as follows: 6, 7, 4, 3, 1, 2, 6, 6, 6, 7, 4, 4. Make a frequency table and then make a histogram based on that frequency table. What is the shape of the distribution? O Skewed to the right O Skewed to the left O Bimodal O Symmetricalarrow_forwardWhat is the median of this set of dataarrow_forward
- Find the percentil for the data point. Data set: 5 12 9 7 5 5 12 7 5 12 2 12 15 6 9 5 12 9 7 12;data point 6arrow_forwardBackground: You just finished teaching your first PSYCH 248 lab section, and it’s time to calculate the grades. Your wonderful teaching assistant created an Excel file with all of the students’ exam grades, homework grade, and lab grade as well as their gender. Your next steps are to calculate each student’s final grade, convert those scores to letter grades, and describe the distribution of scores. 2. In Excel, calculate the final Number Grade, Letter Grade, and Z-score for each student. a. To calculate the Number Grade, type a numerical equation after an = sign in a cell or use the =AVERAGE() formula; however, keep in mind that the =AVERAGE() formula will always give you the regular mean, not the weighted mean. Grades for this course are comprised of three parts: lecture exams (60%), homework (20%), and lab (20%). b. To calculate the Letter Grade, use the =IF() formulawith a series of logic statements or enter the data by hand. For this assignment, let’s convert Number Grade into…arrow_forwardWhat do you mean by relative frequency?arrow_forward
- What is the difference between relative frequency and cumulative frequency? Choose the correct answer below. A. Relative frequency of a class is the number of observations in that class, while cumulative frequency of a class is the sum of all the frequencies. B. Relative frequency of a class is the proportion of the data in that class, while cumulative frequency of a class is the number of observations in that class. C. Relative frequency of a class is the percentage of the data that falls in that class, while cumulative frequency of a class is the sum of the frequencies of that class and all previous classes. O D. There is no difference between the two.arrow_forwardFind the 5 number summary for the data shown 13 24 27 28 38 45 46 48 52 78 84 90 5 number summary: Use the Locator/Percentile method described in your book, not your calculator. Add Work Check Answerarrow_forwardGiven the data set: 6, 19, 17, 23, 20, 10. Determine (i). the percentile rank for each test score,arrow_forward
arrow_back_ios
SEE MORE QUESTIONS
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