Your Question: Digital First Industries (DFI) is a provider of software solutions that help individuals and small businesses manage their finances. DFI recently developed and released a set of mobile applications that cater to specific customer needs (BudgetPlus, InvestorPro, SimpleSavings, PayPlan, Transact). To help identify which of these apps is most popular with customers and is worth devoting more resources to, you have been tasked with analyzing data that has been captured and creating a dashboard to track activity. Tasks: Using the data in the Monthly_App_Downloads worksheet: Create a new worksheet called App_Downloads_Reportwith the following four charts (all your charts should be formatted, labelled, and titled appropriately): A clustered column chartshowing the number of downloads for each mobile application over the course of the months from January to June. For this chart, your horizontal axis should consist of month names, and your vertical columns should be based on the downloads for each app during those months. A 2-D regular pie chartshowing the percent breakdown of downloads among the five apps for the month of May. Based on the chart, determine which app was the least popular and provide your answer in the workbook. A clustered column chartshowing the performance of the InvestorPro and SimpleSavings apps over the course of the months from January to June. The chart should contain a data table at the bottom and a linear trend line for each app to highlight the overall traffic trend. Color an increasing trendline as green, a decreasing one as red, or a stable one as black (Note: you will have to format the trend lines manually). A scatter chartfor the InvestorPro app over the course of the months from January to June. Configure the appropriate chart elements to clear display the linear trend line equation estimating the data points for the InvestorPro app. Based on the information in the chart, what would be the estimate for downloads for July? Provide your answer in the workbook.

Your Question: Digital First Industries (DFI) is a provider of software solutions that help individuals and small businesses manage their finances. DFI recently developed and released a set of mobile applications that cater to specific customer needs (BudgetPlus, InvestorPro, SimpleSavings, PayPlan, Transact). To help identify which of these apps is most popular with customers and is worth devoting more resources to, you have been tasked with analyzing data that has been captured and creating a dashboard to track activity. Tasks: Using the data in the Monthly_App_Downloads worksheet: Create a new worksheet called App_Downloads_Reportwith the following four charts (all your charts should be formatted, labelled, and titled appropriately): A clustered column chartshowing the number of downloads for each mobile application over the course of the months from January to June. For this chart, your horizontal axis should consist of month names, and your vertical columns should be based on the downloads for each app during those months. A 2-D regular pie chartshowing the percent breakdown of downloads among the five apps for the month of May. Based on the chart, determine which app was the least popular and provide your answer in the workbook. A clustered column chartshowing the performance of the InvestorPro and SimpleSavings apps over the course of the months from January to June. The chart should contain a data table at the bottom and a linear trend line for each app to highlight the overall traffic trend. Color an increasing trendline as green, a decreasing one as red, or a stable one as black (Note: you will have to format the trend lines manually). A scatter chartfor the InvestorPro app over the course of the months from January to June. Configure the appropriate chart elements to clear display the linear trend line equation estimating the data points for the InvestorPro app. Based on the information in the chart, what would be the estimate for downloads for July? Provide your answer in the workbook.

MATLAB: An Introduction with Applications

6th Edition

ISBN:9781119256830

Author:Amos Gilat

Publisher:Amos Gilat

Chapter1: Starting With Matlab

Section: Chapter Questions

Problem 1P

See similar textbooks

Tasks:

Using the data in the Monthly_App_Downloads worksheet:

Create a new worksheet called App_Downloads_Reportwith the following four charts (all your charts should be formatted, labelled, and titled appropriately):
- A clustered column chartshowing the number of downloads for each mobile application over the course of the months from January to June. For this chart, your horizontal axis should consist of month names, and your vertical columns should be based on the downloads for each app during those months.
- A 2-D regular pie chartshowing the percent breakdown of downloads among the five apps for the month of May. Based on the chart, determine which app was the least popular and provide your answer in the workbook.
- A clustered column chartshowing the performance of the InvestorPro and SimpleSavings apps over the course of the months from January to June. The chart should contain a data table at the bottom and a linear trend line for each app to highlight the overall traffic trend. Color an increasing trendline as green, a decreasing one as red, or a stable one as black (Note: you will have to format the trend lines manually).
- A scatter chartfor the InvestorPro app over the course of the months from January to June. Configure the appropriate chart elements to clear display the linear trend line equation estimating the data points for the InvestorPro app. Based on the information in the chart, what would be the estimate for downloads for July? Provide your answer in the workbook.

Month
January
February
March
April
May
June
BudgetPlus
22058
22512
20691
24653
24579
30996
Monthly App Downloads
PayPlan
InvestorPro
38418
38731
50643
52151
57479
45520
18297
33731
28874
21149
21242
28205
SimpleSavings
27659
28629
31376
33940
26376
24732
Transact
44975
54891
50782
61995
51505
51809

Expert Solution

Step by step

Solved in 5 steps with 4 images

SEE SOLUTION Check out a sample Q&A here