Kibata

Sign In

Our Services

Get 15% Discount on your First Order

Order Now
[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

Order Now

Related Questions

Discussion Board 3 ( Healthcare Reimbursement)

In your post, compare the characteristics and claims filing processes of private and public payers. What type of ethical issues could arise with personnel during the claims filing processes? Imagine yourself sitting around a conference table with your instructor and classmates. This discussion topic will be similar. It is a

Reading 3

instructions and readings are attached  For section #2 Comparative Insight (7 points) I also attached week 2 reading (Staffing Models)

MATH120

SEE ATTACHMENT  Conditional Probability: What affect does a condition have on the probability?  Let’s compare and find out. Example:   Let’s look at a standard deck of 52 playing cards. No replacement:  What is the probability of getting 2 kings assuming that the first one is not replaced?  (Note:  There are

MGMT496

SEE ATTCHMENT 250-300 WORDS ANSWERING THE FOLLOWING QUESTION This week explain who the potential audience for your e-portfolio will be.  How will you ensure that your e-portfolio is well received by the audience?  What acronyms do you use in your workplace that can cause confusion?  If you are including a

Government and Politics

Details attached.   The role of government in the economy is often debated by economists and businesspeople. 

HRM 6302 Unit V DBR

2 Employment Law HRM 6302 Unit V DB Reply 1 Posts to others should be a minimum of 150 words and use at least one supporting reference. You can use the text for this course as one of the reference sources. Reply to student post below Part I Under the Federal

Fin 6301 Unit VI PPP

2 Corporate Finance ECO 6301 Unit VI PowerPoint Presentation This assignment measures your mastery of ULOs 5.1, 5.2, and 5.3. The purpose of this PowerPoint Presentation is to analyze fundamental aspects of corporate finance management in multinational corporations. You will research a multinational corporation to focus on for the assignment,

gender

 In this summarize, Gallant writes mostly about gender and sex work. How might her ideas be expanded to consider gender in other areas of life?  

Real Estate Evaluation| Neighborhood Analysis

Identify and evaluate the neighborhood within which you live? Create a neighborhood profile using internet links and personal information that will provide some specific data. Draw some inference from this evaluation. Be sure to understand the term neighborhood and what makes this neighborhood different. Is it close to jobs? How

week 3 dicussion Organizational Behavior

 What are the factors that influence our perception? What is the link between perception and decision making? How do individual differences and organizational constraints influence decision making? 

FIN 6301 Unit V DB R1

2 Corporate Finance ECO 6301 Unit V DB Reply 1 • Your response post to class classmate should be at least 150 words in length. • Your response post should include at least one APA-formatted scholarly, professional, or textbook reference with accompanying in-text citation to support any paraphrased, summarized, or

FIN 6301 Unit V DB R2

2 Corporate Finance ECO 6301 Unit V DB Reply 2 • Your response post to class classmate should be at least 150 words in length. • Your response post should include at least one APA-formatted scholarly, professional, or textbook reference with accompanying in-text citation to support any paraphrased, summarized, or

BUSINESS (NO PLAGARISM A+ WORK, ON TIME)

discussion and assignment ASSIGNMENT Brand Extension Assignment For this assignment, you are asked to choose an  existing brand and create a  brand extension for that brand. This is not connected to your final paper topic, so you can use any brand, including your final paper topic for this deliverable. Your goal is

Cash Budget

See attached Please complete Excel template provided The goal of this assignment is to demonstrate the process of construction and utilization of a cash budget for a company. The assignment is closely related to Course Objectives #02. For this assignment we consider the monthly cash budget for six months (January

Final Project: Present a Business Plan

   Final Project: Present a Business Plan WHO: You are the entrepreneur, and your job is to present a business plan for your entrepreneurial venture (I was thinking of a truck parking stop).

Deliverable 7 – Strategic Implementation of Quality Initiatives

  Competencies Analyze the history of healthcare quality improvement and how it shapes current and future quality initiatives. Evaluate patient care clinical outcomes using quality improvement principles. Evaluate healthcare quality measures and their use in diverse populations and settings. Apply models of quality improvement to institutional challenges within the healthcare

Week 4 Discussion Response- Account for Managment Decision Making

Account for Management Decision Making Week 4 Learning Resources Costs There are many different types of costs that impact a manager’s decision making. Therefore, it is imperative that managers understand what each type is as well as the ones relevant to a specific decision. In these resources, you will examine