Our Services

Get 15% Discount on your First Order

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:

May 11, 2025

EXAM QUESTIONS

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

• 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

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.

>Business & Finance homework help

Share This Post

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

Related Questions

to complete this assignment you have to download a free program called JASP link is provided in the assignment instructions.

The Strength of Weak Ties Mark S. Granovetter The American Journal of Sociology, Vol. 78, No. 6. (May, 1973), pp. 1360-1380. Stable URL: The

The Strength of Weak Ties Mark S. Granovetter The American Journal of Sociology, Vol. 78, No. 6. (May, 1973), pp. 1360-1380. Stable URL: The American Journal of Sociology is currently published by The University of Chicago Press. Your use of the JSTOR archive indicates your acceptance of JSTOR’s Terms and

The Strength of Weak Ties Mark S. Granovetter The American Journal of Sociology, Vol. 78, No. 6. (May, 1973), pp. 1360-1380. Stable URL: The

Create the Communication Matrix/Receiver Based demonstrated in the book in Figure 7.1 in a Microsoft Excel format and save it to your hard or flash

Create the Communication Matrix/Receiver Based demonstrated in the book in Figure 7.1 in a Microsoft Excel format and save it to your hard or flash drive so you will have a template when you need one. Upload your newly constructed version with “Your Name” in the Project Manager column.

Explain which HRIS types your current or previous employer utilizes. If your current or previous organization does not utilize an HRIS, which types

Explain which HRIS types your current or previous employer utilizes. If your current or previous organization does not utilize an HRIS, which types would you recommend? How does the utilization of those systems promote transformational HR activities? Discuss the differences between Two-Tier (Client-Server), Three-Tier, and N-Tier architectures. In your opinion,

Stacy McAllister Addressing Negativity in Staff Meetings: A Leadership Perspective As the senior leader of an organization, it is crucial to address

Stacy McAllister Addressing Negativity in Staff Meetings: A Leadership Perspective As the senior leader of an organization, it is crucial to address negativity promptly to maintain a productive and positive work environment. Barrett (2014) emphasizes the importance of immediately addressing negativity to prevent it from affecting team dynamics and performance.

Preparation Complete the following: Choose an organization. (It can be something that interests you, where you work, or a company you are familiar

Preparation Complete the following: Choose an organization. (It can be something that interests you, where you work, or a company you are familiar with.) Access the organization’s website and research the mission and vision statements and code of ethics. Review the QuickStart: Mission and Vision media piece to support your

Creative Work For the past four weeks we have been working on creative material. Now it is time to show me what you have. I grade on how well thought

Creative Work For the past four weeks we have been working on creative material. Now it is time to show me what you have. I grade on how well thought out and the creativity of the social media promotions. You are not graded on the artwork itself. information is in

Project Budget and Project Management Schedule Develop a Project Management Cost (Budget) and Project Management Schedule for Cosmos, Inc. or your

Project Budget and Project Management Schedule Develop a Project Management Cost (Budget) and Project Management Schedule for Cosmos, Inc. or your selected business, using the Project Management Plan template.

Staffing Analysis Interest

Staffing Analysis Interest Rate Applications 4.0% 3098 4.3% 2785 4.3% 2515 4.7% 2180 4.7% 1873 5.2% 1794 5.6% 1450 5.7% 1177 6.1% 822 6.2% 886 6.2% 740 6.8% 740 7.1% 722 7.6% 540 8.3% 375 8.9% 425 9.4% 360 9.5% 389 9.7% 339 9.8% 336

MGT 6203 Three-Year Strategic Plan for Years 11-13 Synopsis Mission and Vision Mission Provide your mission

MGT 6203 Three-Year Strategic Plan for Years 11-13 Synopsis Mission and Vision Mission Provide your mission statement. Vision Provide your vision statement. Corporate Social Responsibility Describe how the organization has been involved with CSR, and the intention of the organization going forward. To Our Stockholders Construct a letter to the

please read instructions and message me. F25 COMPANY: AMAZON All submissions must be no more than 10 pages in length (10 pages are the expected

please read instructions and message me. F25 COMPANY: AMAZON All submissions must be no more than 10 pages in length (10 pages are the expected length) plus appendices/references, written in Times New Roman Font 12 (for readability purposes), double- spaced, with 1.0-inch margins. The appendices and references count as extra

Module 8 – Group Discussion: Chapter 31 – Starting a Business

What leadership behaviors are needed to improve the work environment, determined via your assessment of the employee engagement survey? What

What leadership behaviors are needed to improve the work environment, determined via your assessment of the employee engagement survey? What leadership skills would you recommend including in your organizational leader’s toolkit to develop the identified leadership behaviors? How will improvements in the recommended leadership skills and behaviors improve organizational performance?

Complete the following: · Choose an organization. (It can be something that interests you, where you work, or a company you are familiar with.) ·

Complete the following: · Choose an organization. (It can be something that interests you, where you work, or a company you are familiar with.) · Access the organization’s website and research the mission and vision statements and code of ethics. · Review the QuickStart: Mission and Vision media piece to

Discussion Thread: Problem Statement Development This week you will select an organization and management, or business-related topic related to your

Discussion Thread: Problem Statement Development This week you will select an organization and management, or business-related topic related to your cognate that interests you and construct the following components. You can refer to the resources provided earlier in the course for additional guidance. Post your write-up to the discussion and

Describe the three most important points of the chapter in order of importance. Explain why they are important and how you chose the order of

Describe the three most important points of the chapter in order of importance. Explain why they are important and how you chose the order of importance

Describe the three most important points of the chapter in order of importance. Explain why they are important and how you chose the order of

Describe the three most important points of the chapter in order of importance. Explain why they are important and how you chose the order of importance

Our Services

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:

Share This Post

Related Questions

to complete this assignment you have to download a free program called JASP link is provided in the assignment instructions.

The Strength of Weak Ties Mark S. Granovetter The American Journal of Sociology, Vol. 78, No. 6. (May, 1973), pp. 1360-1380. Stable URL: The

The Strength of Weak Ties Mark S. Granovetter The American Journal of Sociology, Vol. 78, No. 6. (May, 1973), pp. 1360-1380. Stable URL: The

Create the Communication Matrix/Receiver Based demonstrated in the book in Figure 7.1 in a Microsoft Excel format and save it to your hard or flash

Explain which HRIS types your current or previous employer utilizes. If your current or previous organization does not utilize an HRIS, which types

Stacy McAllister Addressing Negativity in Staff Meetings: A Leadership Perspective As the senior leader of an organization, it is crucial to address

Preparation Complete the following: Choose an organization. (It can be something that interests you, where you work, or a company you are familiar

Creative Work For the past four weeks we have been working on creative material. Now it is time to show me what you have. I grade on how well thought

Project Budget and Project Management Schedule Develop a Project Management Cost (Budget) and Project Management Schedule for Cosmos, Inc. or your

Staffing Analysis Interest

MGT 6203 Three-Year Strategic Plan for Years 11-13 Synopsis Mission and Vision Mission Provide your mission

please read instructions and message me. F25 COMPANY: AMAZON All submissions must be no more than 10 pages in length (10 pages are the expected

Module 8 – Group Discussion: Chapter 31 – Starting a Business

What leadership behaviors are needed to improve the work environment, determined via your assessment of the employee engagement survey? What

Complete the following: · Choose an organization. (It can be something that interests you, where you work, or a company you are familiar with.) ·

Discussion Thread: Problem Statement Development This week you will select an organization and management, or business-related topic related to your

Describe the three most important points of the chapter in order of importance. Explain why they are important and how you chose the order of

Describe the three most important points of the chapter in order of importance. Explain why they are important and how you chose the order of

Use Our 6 Free Tools

How Our Service is Used:

Subscribe

NO SPAM