WE SHOULD COMPLETE THE TASK USING A PAPER AND PENCIL IN ORDER TO DRAW THE TABLE IN AN EXCEL FORM. PLEASE COMPLETE THE TASK BY HAND (PAPER) TO HAVE THE TABLE CLEARLY.

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 Microso Excel (Pivot Tables/Charts) and Power BI to analyze this dataset and provide actionable insights to improve C ycling's business operations. The dataset includes trip 1D, trip duration (in minutes), rental start/end time, bike 1D, start/end station IDs, and user type (e.g., casual member or annual member). 0 A trip is dened 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. tion : Part 1: Data Analysis with MS Excel (15 Marks) 0 Load the dataset into Microso Excel and use Pivot Tables to answer the following questions: Q]: Total number of trips (3 Marks). Q2: Average tn'p 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