I know how to import excel datas to MATLAB.

[num,txt,raw] = xlsread('filename')

But I am totally stuck in computing the number of nice, cold and hot days. I know that I should assign number between the given temperature intervals to a variable. But I cannot figure out how to do that. I would really appreciate if someone could explain briefly. If I could only assign the the temperature between the 3 given intervals into 3 main identifiers(hot,cold,nice) I could solve the problem too. I just cannot understand how I can use the math equation 70

The Excel data File link: https://expirebox.com/download/6fc80b5bc02e6c5984055cef26752e7f.html

If it helps, I found this very similar problem on internet "https://www.kau.edu.sa/Files/0053697/Subjects/chapter8-appendix1.pdf" however, it is explained for c programming. not for MATLAB.

The accompanying Excel File ('New_Brunswick_Temp_Data.xlsx') contains the average daily temperature data for New Brunswick from 1981 to 2010. Suppose that the days with average temperature between 70 degrees to 80 are considered nice days, the days with average temperature less than 70 degrees are cold and the days with average temperature more than 80 degrees are considered hot days. Hint: Pay attention to the directives that are given at the top of the Excel sheet. a) Write a MATLAB code to read the data from the Excel file and compute the number of nice, cold and hot days. b) Compute the average temperature in a cold, nice and hot day