I have a project and need help with the Excel part. Please create a vertical bar pivot chart to visualize the profit by year. Include a descriptive chart title and labeled vertical axes.
The data is all in the excel.
this is the full instructions for the assignment:
Using the data, calculate an estimate of gross profit on each movie
Rank the movies from highest to lowest profitability.
Create a pivot table to summarize and rank the profit by year.
Create a vertical bar pivot chart to visualize the profit by year. Include a descriptive chart title and labeled vertical axes.
Is there an effect based on year of release? Explain. What may be the cause for this effect?
Please see if everything else is right & help answer the last question (Is there an effect based on year of release? Explain. What may be the cause for this effect? )
Leave a Reply
You must be logged in to post a comment.