Our Services

Get 15% Discount on your First Order

[rank_math_breadcrumb]

Applied Data Analytics

EXAM QUESTIONS

1

FINAL EXAM

Task 2.3: Final Exam

Assessment type: Exam

Close date: 9 May. 25 (14:00) to 19 May. 25

(14:00)

Weight: 50%

Description: Student is required to answer all questions in the exam consisting of

the content

covered in Units 6 to 10

INSTRUCTIONS

FORMAT

BCOBM122 Applied Data Analysis (5 ETS)

Academic year 2024/25

Semester/Term Spring

Professor
Louisa Carlse, Pete Nicolau,

Resmi Allirani Gopalapillai

Participation in all assessment activities stated in this document is

required. The minimum pass grade for the course is 70. Due dates and times

are always in Geneva time. Unless otherwise stated, the submission point for

Turnitin activities will open exactly 10 days before the deadline. In the case of

exams, the questions will not be available to students in advance.

The Turnitin submission point for the Turnitin (Exam )will open exactly 10 days before the deadline.

The questions will not be available to students in advance.

• Student is required to answer all questions related to content covered in Unit 6, 7, 8, 9 and 10.

• All supporting calculations, workings, formulas and graphs done in MS Excel are to be included as

part of the Excel Workbook submission. Failure to submit supporting calculations or formulas will

result in reduced grades.

• Student is required to make use of supporting data provided to answer the questions. All questions

and all parts to the question is to be answered in full.

• Professional and clear formatting (including appropriate numbering) of questions in the Excel

Workbook is required. Please refer to the below formatting instructions required.

• Student is required to integrate and interpret course content to answer all questions. Please refer to

the detailed rubric for information on how each submission will be graded.

Your submission must meet the following formatting requirements:

• Number of files for submission: 1

EXAM QUESTIONS

2

• Required file format for main submission: Excel spreadsheet (.xlsx) Other details:

• Font: Arial

• Font size: 12

• Spacing: n/a

• Number of words: n/a

• Cover Page: Yes

• Bibliography: Yes.

• All refencing and citations require Harvard referencing style. Students must avoid plagiarism and

use the Harvard Referencing Guide and Turnitin to ensure that their sources are correctly cited.

Plagiarism includes the use of artificial intelligence tools, such as ChatGPT and Grammarly, when

output is copied and pasted from these sites. Please refer to the Academic Policies and

Procedures Manual and the Student Good Practice Manual in AI Literacy available on the

Student Services page for further details.

QUESTION 1: HISTOGRAM CREATION AND ANALYSIS IN EXCEL

You are given a dataset of monthly sales revenues for a retail business over the past two years.

1. Using Excel, create a histogram to visualize the distribution of sales revenues. Ensure to use the

“Data Analysis” toolpack.

2. Interpret the histogram, commenting on the skewness of the data and what this could imply for future

sales forecasting.

3. Based on your analysis, explain whether the business is experiencing consistent sales performance

or if there are fluctuations that may need attention.

QUESTION 2: LINEAR REGRESSION ANALYSIS IN EXCEL

You have data on housing prices, including features such as square footage, number of bedrooms, and age of

the house.

1. Using Excel, create a linear regression model to predict housing prices based on square footage.

2. Analyze the regression output: Interpret the R-squared value, the significance of the coefficients, and

the overall model fit.

3. Discuss the limitations of your model, such as assumptions about linearity, and suggest ways to

improve it.

QUESTION 3: HISTOGRAM COMPARISON

You are tasked with comparing the risk profiles of two investment portfolios over the past year.

1. Using Excel, create histograms for the returns of each portfolio.

2. Compare the histograms in terms of their skewness, spread, and shape. Discuss how these

differences may affect a potential investor’s decision.

3. Based on your interpretation, suggest which portfolio would be better suited for a risk-averse investor.

QUESTION 4: DATA MINING IN RAPIDMINER

EXAM QUESTIONS

3

You are provided with a dataset containing customer demographics and purchasing behavior.

1. Using RapidMiner, build a basic decision tree model to classify customers as high or low spenders

based on their demographic features.

2. Interpret the results of the decision tree, including the key variables influencing the classification.

3. Discuss how businesses can use this model to tailor marketing strategies or product offerings to

specific customer groups.

QUESTION 5: DATA-DRIVEN STORYTELLING

You are preparing a presentation for senior management on the impact of recent marketing campaigns.

1. Create a series of charts and visualizations in Excel to summarize the results of these campaigns

(e.g., sales growth, customer acquisition).

2. Based on your visualizations, write a brief narrative to effectively communicate the business impact of

the marketing campaigns. Be sure to highlight key insights that will guide future marketing decisions.

3. Discuss how the choice of visuals (e.g., bar charts vs. line graphs) influences the clarity and

effectiveness of the message.

Share This Post

Email
WhatsApp
Facebook
Twitter
LinkedIn
Pinterest
Reddit

Order a Similar Paper and get 15% Discount on your First Order

Related Questions

Unit VII

see attached Assignment Instructions You will use the multinational corporation (MNC) you researched in Unit VI for this assignment. The purpose of this scholarly activity is to continue to analyze fundamental aspects of corporate finance management in multinational corporations. You will examine supply chains and working capital management and make

Discussion 1

Write a 350 word response with 1 reference Due 1/6/2026 Discussion Question One: In this course, you will have an opportunity to explore ways to address topics of your interest that may represent challenges or areas in need of improvement or growth facing the organization.  · Considering your position, what

Business Finance – Management MBA 511 Week One Assignment. Powerpoint Presentation 7-8 slides

Week One Assignment Instructions Assignment 1: Assess Emotional Intelligence Top of Form Bottom of Form Instructions Competent leadership drives organizational success. Research shows that self-awareness, a central aspect of Emotional Intelligence, is more crucial for effective leadership than IQ or technical skills (Showry & Manasa, 2014). Self-awareness underpins managerial capability

sdddjsjs

Personal Reaction Paper Instructions: The purpose of the assignment is to reflect on the concepts gleaned from reading chapters 1 – 3 of the required textbook ( Human Resource Management). The objective of the paper is to analyze how human resource concepts apply to employees and the organizations they are

7-1 Discussion: What Would You Do Differently?

 For this discussion, describe a persuasive message that your workplace leader sent to an audience who resisted the idea, product, or service. Imagine yourself as a member of the audience. What would you recommend to the leader to better construct the message to get the intended results? Identify at least

Week 7 Discussion- Delivery of Healthcare

Continuum of Care Scenario: Team B Discussion 1 In this Discussion, you will continue to analyze your continuum of care scenario using the value-based care model, the IOM Aims, and a country comparison. You will be placed into a team and share your suggestions for improvements. Then, you will provide

Week 7 Discussion- Managerial Finance

Using Financial Forecast  Financial forecasts are crucial for businesses to make informed decisions, allocate resources effectively, and measure performance. They are typically based on historical data, which can make it challenging to predict sudden changes in market conditions or business operations. To mitigate financial risk, managers can employ strategies such

week 5

 overall business strategy your canvas depicts.  Assignment Directions: GOAL: Build on your work with your business model canvas by discussing the patterns, the design, and the overall business strategy it illustrates.  Introduction: Using the week 5 Learning Material in the Content area (coupled with the other course resources), examine and discuss

BUSN100

See attached. Instructions For this assignment just type the transcript Assignment Instruction: You are the public information officer (PIO) for a small company, responsible for communicating and distributing information for your organization. Prompt In this scenario, an unexpected incident has occurred within your local community, impacting the safety of employees

MKTG201

see attached Instructions: EOS Brand Assignment Directions: Objective:  For this assignment, you will explore how brands implement Integrated Marketing Communications (IMC) by evaluating their ability to deliver a consistent message across various marketing channels. Start by selecting a brand that interests you; this can be a well-known company or a

Unit V

see attached Post 1: Initial post addressing the discussion board topic • Your initial post should be at least 300 words in length. • Your initial post should include at least one APA-formatted scholarly, professional, or textbook reference with accompanying in-text citation to support any paraphrased, summarized, or quoted material.

Is Royal Ludo a good first online game?

  Royal Ludo stands out as a welcoming entry point into online real-money gaming, especially for those wary of overly complex platforms. It emphasizes simplicity, familiarity, and low-risk learning. With easy   <a href=” Ludo download</a> options and cross-device compatibility, it’s accessible to everyone.  

How Do Pattern Recognition and Timing Affect Success in Stock Trading

 How does understanding market behavior in sideways trends (like TTQA shifts in sentiment and large vs. small fund activity) compare to recognizing patterns and timing in a game like [url= surfers[/url]  , where success depends on reading the level and reacting at the right moment? 

Create a Shipping list for the items bellow. It needs to be editable

   six-bedroom household shipment.  List of items in shipping Container: * Two (2) dining table sets * Three (3) living room couch sets * Washer and dryer * Two (2) master bedroom furniture sets * Four (4) regular bedroom furniture sets , (2) Kids’ basketball court  10 Children’s toys and

Week 6 Discussion- Delivery of Healthcare

Continuum of Care Scenario: Team A Discussion 3 For this team Discussion, you will have the opportunity to review the work of others and provide them with peer-reviewed feedback, as well as consider how their continuum of care might be improved. Further, you will be able to compare and contrast

Business Finance – Management Week 5 Assignment- Managerial Finance

Module 2 Assignment: Financial Health Assessment: Barry Computer Company Report prepared by: Replace this text with your name. Date: Replace this text with the submission date. Walden University MBAX 6070: Managerial Finance 1 Part 1: Financial Information Replace this text with introductory information. Add or remove headings as necessary. [Heading]

Week 8 MGMT601

 align and discuss the implications for organizational commitment   Assignment Directions:  You will conduct an interview with a colleague or contact currently employed, focusing on their perceptions of the psychological contract with their employer. You will then write a 3–5-page report outlining the unwritten expectations from both the employee and