DO PROBLEM 8-38 and please show where you got the answers and formulas .
Application Exercises
Note: The existing data files referenced in these exercises are available on the book's Web site www.pearsonhighered.com/valacich. I. 143-Es.
Spreadsheet Application: Tracking Web Site Visits at Campus Travel
8-38.
Campus Travel has recently started selling products on the Internet; the managers are eager to know how the company's Web site is accepted by the customers.
The file CampusTravel.csv contains transaction information for the past three days, generated from the company's Web server, including IP addreises of the visitors, whether a transaction was completed, and the transac-tion amount.
You are asked to present the current status of the e-commerce initiative. Use your spreadsheet pro-gram to prepare the following graphs:
A graph highlighting the total number of site visits and the total number of transactions per day G A graph highlighting the total sales per day
Make sure to format the graphs in a professional manner, including headers, footers, and the appropriate labels, and print each graph on a separate page.
(Hint: To calculate the total number of site visits and the total number of transac-tions, use the "countif' function to count the number.)
Attachment:- CampusTravel.rar