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

BUSINESS (NO PLAGARISM A+ WORK, ON TIME)

response Response SJ (no more than 150 words) If my best friend owned a small children’s clothing store in a downtown area losing traffic to larger retailers and new strip malls, I would first recommend focusing on differentiation, community connection, and digital visibility, three areas where small businesses can compete

Mid term

Essay Assignment: Personal Impact of a Key Concept in Negotiation and Conflict Management Assignment Title: “The Concept That Changed My Perspective: A Deep Dive into Negotiation and Conflict Management” Word Count: Minimum: 1000 words Maximum: 1500 words Due Date: Submitted in Microsoft Word format and uploaded into WebCampus by October

Corporate risk

 Analyzing the impact of dividend policies on shareholder value and evaluate the use of financial derivatives to manage corporate risk.

BUSINESS (NO PLAGARISM A+ WORK, ON TIME)

Discussion – Real World example (No more than 200 words) Your best friend owns a small children’s clothing store located in the downtown area of a community of 50,000 citizens. The business has been slow the past year due to the construction of several new strip malls and a new

D7

Final Risk Management Plan: Risk Monitoring and Control Assignment Instructions Compile the previous week’s assignments for the risk management plan and submit as one document and add the Risk Monitoring and Control section. · Cover Page: Include your name, the project or company name, and the course name and number.

HTM

instructions attached It is ironic that California, as the state that provides the bulk of the nation’s fresh fruits and vegetables, has such disparity between the haves and have nots. Similarly, it’s also ironic that the hungriest Californians, also suffer from obesity and diabetes. Based on the content from this

Business

instructions and reading attached  1. Please use ChatGPT, Google or other online sources to formulate and ask a question about organizing for collective bargaining. Your question can involve anything from legal aspects, to employer anti-union campaigns etc. Why did you pick this question? What answer did you find and what

Week 8 Discussion- Marketing for Competitiveness

Persuasion and Positive Social Change In this course so far, you have begun to engage with the idea of persuasion as it applies to marketing. In the Week 5 Discussion, you reflected upon a buying experience in which you were persuaded, through marketing efforts, to make a purchase. Now think

Unit

Business Law 431 The Law of Commercial Transactions Unit 2 Assignment Please read each question carefully and draft your answers, making sure to address each part of each question. Upload your answers to the Unit 2 Assignment dropbox on Westernonline. 1 Search online to find examples of the following: a.

purpose and role that each type of financial institution in US economy

   Briefly discuss the purpose and role that each type of financial institution (depositary, contractual, and investment) play in the U.S. economy. How do each of these institutions intersect with the various types of markets, i.e., capital, money, spot (cash), derivatives, Forex and Interbank, primary, and secondary (inclusive of OTC)?

financial management (Ethics)

 Using your Wall Street Journal subscription, select an article about any publicly traded firm that enjoys a large shareholder base. How has the company incorporated ethics into the financial management practices? Discuss what challenges the firm has encountered (or is likely to encounter) and how it has sustained ethical practices

MGMT496

SEE ATTACHED Instructions Write a rationale paper describing the artifacts in the e-portfolio and how they demonstrate skills, knowledge, understanding of theory, professional disposition, real-world application, and mastery of the program objectives.  Word documents should be a minimum of 3 pages in length  not  including a cover/title page

Business Management

Working Together Competencies 304.6.3 : Working with Individuals and Groups The graduate is knowledgeable about strategies for working with individuals and groups in an organization. Introduction There are four key barriers to communication: process barriers, personal barriers, physical barriers, and semantic barriers. Requirements Your submission must represent your original work

Business Management

Managing Innovation 304.4.4 : Managing Innovation The graduate is knowledgeable about managing innovation. Introduction Organizations often try to develop an entrepreneurial culture through a strong orientation toward entrepreneurship. Requirements Your submission must represent your original work and understanding of the course material. Most performance assessment submissions are automatically scanned through

journal

need done by today Supply and Demand Curves Worksheet Data The following graph illustrates a standard supply and demand model, which shows the relationship between price and quantity in a competitive market. Complete the worksheet, using this graph as a reference. Long description: The graph illustrates a standard supply and

7-1 Discussion: Contract Law

 Find a recreation- or sport-related current event related to contract law. Discuss the court’s decision. Applying what you learned in this week’s module, do you agree/disagree with the court’s decision? Justify your answer.