What problem is big data helping the company to resolve?
Assessment Brief: Task and General Guidelines
Scenario:
What problem is big data helping the company to resolve?
Identify the data used by the company and evaluate the practices followed to use this data.
Analyze the challenges the company had to overcome in order to successfully use data for decision-making.
Refer to data file BankClosures.
Which state had the greatest number of insured bank closings between 2000 and 2012?
How many bank closings occurred in the state of Nevada in 2010? In what cities did these closings occur?
Use the PivotTable’s filter option to view bank closings in California, Florida, Texas and New York for the years 2009 through 2012. What is the total number of bank closings in these states between 2009 and 2012?
Create a PivotChart to display a column chart that shows the total number of bank closings in each year 2000 through 2012 in the state of Florida. Make sure that your formatting of the chart best conveys the data. Based on the chart, suggest about bank closings between 2000 through 2012 in Florida. Briefly discuss your findings.
Refer to VehicleProduction.
Create a line chart for the time series data for years 1 through 5 showing the number of vehicles manufactured by each company. The time series for all manufacturers should be displayed on the same graph.
Based on the line chart that you have created, comment on what you infer about the production amounts between years 1 through 5.
Construct a clustered bar chart showing vehicles produced by vehicle manufacturers using the data for years 1 through 5. Make sure that you represent the years of production along the horizontal axis and cluster the production amounts for the four manufacturers in each year. Identify which is the leading manufacturer in each year.
Refer to file StatScore.
Assign hours of studying as the independent variable and develop a scatter chart. Comment on the relationship between hours of studying and the score gained in the course.
Using the given data, develop a regression equation which can be used to predict the score gained to the hours of studying.
To what extent does the model explain the variation in the sample values of scores gained in the course?
If a student spend 95 hours of studying statistics, use the model that you developed to predict the score that he/ she is likely to gain.
Netflix managers have tirelessly collected and analyzed information to build lucrative markets where none previously existed. Those insights allowed it grow into the only worldwide streaming network. Today, the service has 137 million subscribers and is on pace to do $15 billion in sales through fiscal 2018. [Source: https://www.forbes.com/sites/jonmarkman/2019/02/25/netflix-harnesses-big-data-to-profit-from-your-tastes/#53f0ed5b66fd]
The following questions have to be answered with reference to the preceding scenario: (The student is encouraged to refer to appropriate literature sources and provide proper referencing wherever needed.)
[10 marks, 600 words]
[10 marks, 600 words]
[10 marks, 600 words]
Note: For Questions 2 to 4, use MS Excel for data analysis.
This file gives you the data on failures of banks between 2000 and 2012. Create a PivotTable in Excel which group the closing dates of the banks into yearly bins and display the counts of bank closures each year in columns. Make sure that the row labels include the bank locations and allow for grouping the locations into states or viewing by city. Sort the PivotTable so that the states with the greatest number of total bank failures between 2000 and 2012 appear at the top of the PivotTable.
[5 marks]
[5 marks]
[5 marks]
[10 marks]
The file gives the details on the number of vehicles produced by different manufacturers in five different years.
[10 marks]
[5 marks, 300 words]
[10 marks]
A statistics professor at Eaton Business School is interested in the relationship between hours of studying and the score gained in a course. Data has been collected on 156 students who attended the course in the previous semester.
[5 marks x 4 = 20 marks]
Requirements:
Collepals.com Plagiarism Free Papers
Are you looking for custom essay writing service or even dissertation writing services? Just request for our write my paper service, and we'll match you with the best essay writer in your subject! With an exceptional team of professional academic experts in a wide range of subjects, we can guarantee you an unrivaled quality of custom-written papers.
Get ZERO PLAGIARISM, HUMAN WRITTEN ESSAYS
Why Hire Collepals.com writers to do your paper?
Quality- We are experienced and have access to ample research materials.
We write plagiarism Free Content
Confidential- We never share or sell your personal information to third parties.
Support-Chat with us today! We are always waiting to answer all your questions.
