{please see the attachment To solve the question in excel. . Below is a list for question and you need to answer it in attachment. }

(The following table lists the number of trips (in thousands) made by Canadian)

residents in Canada by trip purpose, third quarter of 2019.

Trip Purpose Number of Trips (in thousands)

Business 5500

Pleasure 41100

Visiting friends/relatives 33800

Other 11100

a. Find relative frequency for each category. What information can you withdraw from the

data?

1. b. Which statistical graphs can be used to represent this data set? Why?

Data for Question 1 Trips by Canadian residents in Canada by trip purpose, third quarter of 2019 Trip Purpose Business Pleasure Visiting friends/relatives Other Number of Trips (in thousands) 5500 41100 33800 11100 Note: The "Other" category includes travel to shop, to attend a personal conference, convention or trade show, or for other pe Source(s): https://www150.statcan.gc.ca1/daily-quotidien/200226/t001c-eng.csv National Travel Survey (5232). Table 24-10-0045-01. tion or trade show, or for other personal reasons. Data for Question 2 Annual Salary (in $1000s) 34 45 53 49 60 75 61 47 55 76 67 58 56 69 80 86 Data for Question 3 Advertising ($1000s), X 6.9 4.4 5.3 5 6.7 5.7 6.6 5.2 6.9 5.8 Weekly Gross Revenue ($1000s), Y 98.5 89.3 95.4 92.2 95.6 94.4 95.9 94.7 95.8 94.2