Organizing and analyzing The first step is to organize the data, so that you cananalyze it and identify trends. You will organize the data using an Excel workbook; remember as noted above your Data Set is available on eConestoga under Evaluations > Data Analysis Assignment. To help in your analysis, consider the following tips: 3) You will want to use separate worksheets to organize the date into various segments - by genre, by studio, by year. b) Calculate the market share of each studio, and the segment share of each genre. This should be done for each year. c) Calculate the relevant trends; this will include growth/decline of sales, of profit, of market share and of segment share. Trends must be calculated year by year (e.g. how much did sales increase from 2018 to 2019, from 2019 to 2020 etc.). Note: i) Trends based on $ (eg sales) are best indicated by % change, not by $ value (eg $32,600 sales to $33,000 is a 1.2% increase). ii) Trends based on % (eg market share, segment share) are best indicated by point change (eg difference from one year to the next; 32.6 % share to 33.0% share is a .4 increase). ili) Analyze trends overall (profit, sales), and also by genre and studio. d) Be sure to use pivot tables to help you identify trends. For example, using pivot tables to evaluate the relationship between Audience Score and Sales, and Rotten Tomatoes Rating and Sales can be helpful in determining which is the better predictor of success