In Excel, construct a relative frequency distribution with a class width of 0.5 and a lower class limit for the first class equal to 96.0.

Data:
- 96.7, 96.8, 96.9
- 97.1, 97.1, 97.1, 97.2, 97.3, 97.3, 97.4, 97.5, 97.5, 97.6, 97.6, 97.7, 97.7, 97.7, 97.7, 97.8, 97.8, 97.8, 97.8, 97.8, 97.9, 97.9
- 98.0, 98.2, 98.3, 98.3, 98.3, 98.4, 98.4, 98.4, 98.4, 98.4, 98.6, 98.7
- 98.8, 98.9, 98.9, 98.9, 98.9, 99.1, 99.2

Instructions:
1. Enter the data into an Excel spreadsheet.
2. Determine the class limits starting from 96.0 with a class width of 0.5.
3. Count the frequency of data points within each class.
4. Calculate the relative frequency for each class by dividing the frequency by the total number of data points.
5. Plot the relative frequency distribution.

To construct a relative frequency distribution in Excel with a class width of 0.5 and a lower class limit of 96.0, follow these steps: Enter the provided data in a column in Excel. Sort the data in ascending order. Calculate the number of classes based on the range and class width. Create a column for the classes, starting from the lower class limit and incrementing by the class width. Create a column for the frequency count using the COUNTIFS function to count the values within each class. Create a column for the relative frequency by dividing the frequency count by the total count. Format the cells as desired. By following these steps, you can construct a relative frequency distribution in Excel with the given class width and lower class limit, allowing you to analyze the data and observe patterns or trends.

To learn more about Frequency

https://brainly.com/question/28821602

#SPJ11