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

AI Case study

Help with homework today   AI solution justification using the AI Strategy Framework + Technical prerequisites: An evaluation to determine whether the identified problem needs the proposed AI solution 

DEFM200

see attached Instructions Assignment Directions Create a five-to-seven-page essay, excluding title and reference pages, in APA format, using the current APA information in the library writing resources section. Include the following sections: an introduction, a summary of FAR Part 16, a review of relevant library articles, integration of these sources,

SCMG201

see attached Discussion Prompt: In this week’s discussion you will evaluate logistics as a supply chain component, including how to measure performance and key strategies to improve effectiveness. Choose a topic from the following list (taken from Sanders, p. 157):  · Imagine that you are starting an online retail business.

BUSINESS MANAGEMENT A+ WORK, ON TIME, NO PLAGARIZING

Tutor Discussion/Assignment 2 RESUME PEER REVIEW To: [Classmate’s Name] From: [Your Name] RE: BUSN696, Resume Peer Review DATE: [Date] Introduction [INSTRUCTIONS: IN THIS SECTION – NO MORE THAN 2 SENTENCES INTRODUCING YOUR PEER REVIEW] Summary of Review Criteria and Research [ INSTRUCTIONS: IN THIS SECTION – BRIEF PARAGRAPH EXPLAINING REVIEW

discussion forming a business

BUSI 301 Discussion Assignment Instructions Overview Discussions bring dialogue and communication into our learning experience. Unlike so much of the unsubstantiated opinion we see in the public square and social media, these discussions provide a space for in-depth analysis and application of the topics in our Learn readings and presentations.

reply

reply to these 2 people BUSI 301 Discussion Assignment Instructions Overview Discussions bring dialogue and communication into our learning experience. Unlike so much of the unsubstantiated opinion we see in the public square and social media, these discussions provide a space for in-depth analysis and application of the topics in

synthesis

Areas of study are: health and business admin. INDS 491 Synthesis Essay Assignment Instructions Overview The Synthesis Essay will give you a chance to understand and explain how your areas of study influence each other and how all of them come together to help you move on to the next

methodology

i included a copy of the topic research we have been working on  1 Work Absenteeism: Can Wellness Implementation Decrease It? Tanesha Blythe Liberty University INDS491: Interdisciplinary Studies Capstone (C03) Professor Stephen Milacci March 2, 2026 Discipline: Health & Business Administration 2 Work Absenteeism: Can Wellness Implementation Decrease It? Topic:

Week 3 df

 United Nations Sustainable Development Goals (SDGs) and their expectations for all businesses by 2030 

BUSINESS (NO PLAGARISM A+ WORK, ON TIME)

tutor discussion and response CHAPTER 7 Risk Analysis, Real Options, and Capital Budgeting Page 205 Even in the best of times, movies often bomb at the box office. In May 2023, the movie Hypnotic, starring Ben Affleck and Alice Braga, hit theaters with the slogan, “Control is an illusion.” But

Business Finance – Management 3-3 Assignment: Stakeholder Roles and Responsibilities

SEE ATTACHMENT  Module Three Assignment Guidelines and Rubric.html QSO 321 Module Three Assignment Guidelines and Rubric Overview Knowing the expectations involved with maintaining operational sustainability and who is responsible for meeting these expectations is an important part of being an effective practitioner. In this assignment, you will create a guide

Business Finance – Management ACC 202 Module Three Assignment

SEE ATTACHMENT Module Three Assignment Guidelines and Rubric.html ACC 202 Module Three Assignment Guidelines and Rubric Overview Companies choose their costing method based on their business activities and processes, as well as the products and services they offer. A company can be a manufacturing, merchandising, or service organization; this also

Demonstrate Your Key Performance Indicator (KPI) Knowledge. Length: 10-12 slides, including audio for each slide (SEE INSTRUCTIONS). References: Include a minimum of 5 scholarly references.

Assignment 6: Demonstrate Your Key Performance Indicator (KPI) Knowledge Instructions Although there are many key performance indicators, a goal from the lesson is to focus on a few strategies to drive success for your new product. For this assignment, you will identify KPIs for pricing, promotions, and overall success. An important role for marketing managers

Business Case Study

Help with homework. BUS 330 – Final Case Study In the second half of our class, we have been focusing on some key economic forces/variables (e.g., interest rate, exchange rate, price fluctuations, unemployment, trade policies, etc.) that affect organizations in different manners. A primary objective in this class is to

6-1 Final Project Milestone Three: Financial Analysis Listen

 n Milestone Three, you will submit a financial analysis of the sport organization and selected market. You will first provide a financial overview of the organization, including the most up-to-date balance sheet. Then you will estimate capital requirements for the project and predict whether expansion would or would not be

Deliverable 6 – Chronic Diseases and Population Health Management

  Scenario The key to an effective and sustainable population health management program is to understand your chronic disease patients and coach them towards a healthy lifestyle. The success of population health and chronic disease management efforts hinges on a few key elements: Identifying those at risk and the health

Deliverable 5 – Population Health Management Patterns

  Scenario Effective population health management (PHM) requires strategies to reach the individual consumer or patient at all stages of life in the manner most appropriate for each individual. PHM must use a set of patterns of population health strategies that describe people and their preferences. These pattern classifications help