Answered step by step
Verified Expert Solution
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.
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
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started