Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

WE SHOULD COMPLETE THE TASK USING A TABLE IN AN EXCEL FORM. Description: You are a data analyst working for Cycling, a bicycle rental company

WE SHOULD COMPLETE THE TASK USING A TABLE IN AN EXCEL FORM.

image text in transcribed
Description: You are a data analyst working for "Cycling", a bicycle rental company operating in North America. Cycling offers various types of bikes for rent, and you have access to a dataset containing trip information for the rst day of January 2023. Your task is to use both Microsoft Excel (Pivot Tablesa'Charts) and Power BI to analyze this dataset and provide actionable insights to improve Cycling' 5 business operations. The dataset includes trip lD, trip duration (in minutes), rental startfend time, bike 10, startfend station IDs, and user type (e. g., casual member or annual member). 0 A trip is defined as any valid rental one minute or longer. 0 Assume the pattern you see on the dataset for this day will be similar to the pattern you may see during the whole year. Questions: Part 1: Data Analysis with MS Excel (15 Marks) 0 Load the dataset into Microsoft Excel and use Pivot Tables to answer the following questions: Q]: Total number of trips (3 Marks}. Q2: Average trip duration (4 Marks). Q3: Total number of trips by user type (3 Marks}. Q4: Create a Pivot Chart to visualize the distribution of trips by user type and interpret the chart (5 Marks}

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Marketing Hospitality

Authors: Cathy H C Hsu, Tom Powers, Thomas F Powers

3rd Edition

0471348856, 9780471348856

More Books

Students also viewed these General Management questions

Question

How are prices derived?10-1.

Answered: 1 week ago