Data Entry and Project Implentiation

sdotholla

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 Week3_CampusTravel.csv contains transaction information for the past three days, generated from the company's Web server, including IP addresses of the visitors, whether a transaction was completed, and the transaction amount. You are asked to present the current status of the e-commerce initiative. Use your spreadsheet program to prepare the following graphs:

 

  1.  A graph highlighting the total number of site visits and the total number of transactions per day.

 

      2.     A graph highlighting the total sales per day.

 

    • Please make sure you document the two (2) graphs proficiently and professionally.  

 

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 transactions, use the "countif" function to count the number). 

 

  • 10 years ago
  • 45
Answer(1)

Purchase the answer to view it

NOT RATED
  • transactions.xlsx
  • your_lastname_week3_database-assmt.accdb