Category: Analytics

I have attached the Instructions.  The paper needs to include Excel charts and/or graphs    for analysis. I have included the original business idea. This paper requires knowledge of   business analytics and marketing research.

The main focus of this project is for you to find/gather,
organize, analyze and present data. You will be choosing a topic, designing and
carrying out a statistical study. Your study will include relevant descriptive
statistics that you have learned about in this course. 
Type of Project
First you will need to decide what type of data you will
collect for your project:
Primary
Data is information that you collect on your own. For example, this
could be obtained by having students at your day school complete a
questionnaire on paper or online (using survey monkey,  etc.). Or canvassing respondents in your neighborhood.
Secondary
Data is information that you are taking from another source. It is
important to use reliable sources. When choosing your topic, be sure that
you will be able to find good data. Some places that students often obtain
data from are provided in the “useful
data websites” handout
Sample Projects
This type of culminating
task is very common for the Data Management course. You will be able to find
many project exemplars online.  Be sure
to see what other students have done to get ideas on what works well and what
can be improved upon.
Attached project itself, rubric for it, textbook, ideas, and useful links

You are a business analyst at a private-equity investment organization. You are exploring potential new investment opportunities for your organization. One of the sectors your organization is looking to invest in is sustainable green-energy businesses. The chief investment officer (CIO) has handed you a historical data set on sustainable organizations. The CIO informs you that five new organizations in the sector are looking for investors. You must analyze the historical data to assess whether investing in one of these organizations would be a good decision.
A linear regression model provides ratio values as output. Using the Historical Green Energy Data Set, you will build and apply a linear regression model to predict the profit value for the five new organizations. If an organization’s predicted profit value is a negative ratio value, you may not recommend the organization as an investment opportunity. Similarly, if an organization’s predicted profit is a positive ratio value, you may recommend it as an investment opportunity.
Write a report with your analysis and recommendations about the investment potential of the five new organizations. Specifically, you must address the following rubric criteria:
Data Requirements: Using the given historical data set, identify the information you will need to create the predictive model.
Determine the dependent and independent variables.
Explain the relationship between the dependent and independent variables.
Linear Regression Model: Use the given historical data to build a linear regression equation.
Create a linear regression equation for multiple independent variables.
Strength of the Model: Use the results of the linear regression to assess the strength of the model.
Discuss the summary output, including multiple R, R square, adjusted R square, and sample error.
What do these results tell you about the variables and the data?
How will these results help you predict the investment potential of an organization?
Strength of the Independent Variables: Evaluate the strength of the independent variables to find out which variables have the most impact.
Discuss the degrees of freedom (df), sum of squares (ss), and mean square (MS).
What do these tell you about the historical data and the role of the different independent variables?
Discuss how the model’s coefficients can be used to select the optimal independent variables for the model.
Actual versus Predicted Model: Compare the predicted variable values with the actual variable values.
Explain whether this model is potentially useful for predicting an organization’s profitability.
Show the residual output from the model, and discuss how far the predicted variables are from the actual results.
Recommendation: Provide a recommendation based on the results of the predictive model.
Apply the model to the data from the five new organizations to determine if any of the organizations are profitable for investors.
Provide a recommendation for each of the five organizations.

Final: Integrating and Managing Data for Strategic Success
Background
XYZ Inc. is a medium-sized e-commerce company that has been operating for the past five years. The company has grown rapidly, but so has its data, which is now sprawled across various departments and systems. There are inconsistencies, data quality issues, and a lack of a centralized data governance strategy, leading to challenges in decision-making and business analytics.
Objective
Your task is to assist XYZ Inc. in establishing a comprehensive data management and governance framework to ensure data quality, consistency, and accessibility. This will involve various steps, from assessing the current state of data, initiating a data governance program, and implementing tools and artifacts to support data management.
Data Provided
You will be provided with three datasets:
1.    Customer Data: Information on customers, including their purchasing behavior and feedback.
2.    Product Data: Details of products, including pricing, categories, and stock levels.
3.    Sales Data: Records of sales transactions, including customer details, product purchased, and transaction dates.
Tasks
Task 1: Assessing Data Quality and Governance Maturity
Objective: Evaluate the current state of data quality and the company’s data governance maturity.
Deliverable: A report highlighting the findings of the data quality assessment and a scorecard for the company’s data governance maturity.
Task 2: Initiating Data Governance
Objective: Define the scope of the data governance program and identify the key stakeholders.
Deliverable: A document outlining the scope, objectives, and key stakeholders of the data governance program.
Task 3: Implementing Data Management Tools and Artifacts
Objective: Recommend and implement data management tools and develop key data governance artifacts.
Deliverable: A report outlining the recommended tools, and examples of data governance artifacts such as a data dictionary and data quality metrics.
Task 4: Building a Business Case
Objective: Develop a business case for the data governance program, showcasing the business value and expected ROI.
Deliverable: A comprehensive business case document.
Task 5: Evaluating Business Analytics Capabilities
Objective: Assess how the implemented data governance framework enhances the company’s business analytics capabilities.
Deliverable: A report evaluating the impact of the data governance program on the company’s ability to perform hypothesis testing, regression analysis, and risk assessment.
By completing this case study, you will have applied the principles and practices learned throughout the course, demonstrating your ability to address real-world data management challenges. This hands-on experience will solidify your skills in data governance, ensuring you are well-equipped to drive data-driven decision-making and contribute to the strategic success of any organization.

Case Study #1 is intended to test your knowledge of how to run and interpret the results of a moving average model, a Holt’s exponential smoothing model, and a Winter’s exponential smoothing model.
HeathCo is a manufacturing company that produces a line of skiwear that is sold under various brand names.  The Product Manager of HeathCo has contracted with you to develop a model to forecast company sales.  You will be supplied with quarterly sales data from 2007 through 2016.  They want a model that will allow them to forecast sales one year (four quarters) out.
Develop and interpret models using the methods below.  Use the data from the years 2007 to 2015 to develop models.  Evaluate the fit of your models to the data series used to create the model.  Reserve 2016 data as a holdout to evaluate the accuracy of your models.
Four-period moving average
Holt’s Exponential Smoothing
Winter’s Exponential Smoothing
Submit both the Instructions/Answer sheet and your detailed forecasting model runs. You will submit a single Excel workbook with all relevant sheets.  The first sheet in your workbook will be an answer sheet with clearly labeled answers to all questions and a guide to sheets where supporting Excel information can be found.
Submit the following two documents:
Completed Instructions/Answer sheet
Excel workbook showing forecasting models and formulas used for calculations
Resources:
Below is the data file and the Instructions/Answer sheet for the case study.
HeathCo_Sales.xlsx Download HeathCo_Sales.xlsx 
Week 2 Case Study Instructions and Answer Sheet – BBA 360.docx

Creating a Thesis Statement and Topic Sentences
Hide Assignment Information
Turnitin®
Use the attachment as a example
This assignment will be submitted to Turnitin®.
Instructions
It is time to use what you have learned about thesis statements and topic sentences. 
Begin by choosing a topic: a favorite place, a hated food, a musical group or theatre performance, a best friend, a bully from high school, a profession, something you just learned, a great idea. Whatever you choose, be ready to write a whole essay on it. If you like the topic you chose for the Week 2 Discussion on prewriting strategies, you can use it for this assignment.
Use the topic to write a thesis statement. Make sure you include:
Use the essay map to create a topic sentence for each of the three body paragraphs.
The thesis statement and the three (3) topic sentences should be submitted in the same MSWord file.
Week 3 Sample Assignment from Professor Crawford
Hide Rubrics
Rubric Name: ENGL101 Thesis and Topic Sentences (Week 3) (March 20201)
Print Rubric
This table lists criteria and criteria group names in the first column. The first row lists level names and includes scores if the rubric uses a numeric scoring method. You can give feedback on each criterion by tabbing to the add feedback buttons in the table.
Criteria
Exemplary
Accomplished
Developing
Beginning
Did not attempt
Criterion Score
Thesis Statement
55 points
The thesis is complete with a topic that is neither too broad nor too narrow, a strong argument/assertion, and a well-formulated three point essay map. The thesis is clear and edited, and each point of the essay map is parallel in structure.
44 points
Most of the main requirements of the Exemplary rating are present in some form. Minor work may be required to improve. The thesis may need some revising/editing.
39 points
Several of the main requirements of the Exemplary rating are missing or poorly done. It may need significant revising and/or editing.
33 points
Many of the main components of the Exemplary rating are missing or poorly done. It may need significant revising and/or editing.
0 points
Did not attempt.
Score of Thesis Statement,
/ 55
Topic Sentence 1
15 points
The topic reflects but does not repeat the first point in the essay map. It states a strong argument/assertion, is mostly free from error, and is written to appeal to the reader.
12 points
Most of the main requirements of the Exemplary rating are present in some form. Minor work may be required to improve. TS1 may need some revising/editing.
11 points
Several of the main requirements of the Exemplary rating are missing or poorly done. It may need significant revising and/or editing.
9 points
Many of the main components of the Exemplary rating are missing or poorly done. It may need significant revising and/or editing.
0 points
Did not attempt.
Score of Topic Sentence 1,
/ 15
Topic Sentence 2
15 points
The topic reflects but does not repeat the second point in the essay map. It states a strong argument/assertion, is mostly free from error, and is written to appeal to the reader.
12 points
Most of the main requirements of the Exemplary rating are present in some form. Minor work may be required to improve. Topic Sentence 2 may need some revising/editing.
11 points
Several of the main requirements of the Exemplary rating are missing or poorly done. It may need significant revising and/or editing.
9 points
Many of the main components of the Exemplary rating are missing or poorly done. It may need significant revising and/or editing.
0 points
Did not attempt.
Score of Topic Sentence 2,
/ 15
Topic Sentence 3
15 points
The topic reflects but does not repeat the third point in the essay map. It states a strong argument/assertion, is mostly free from error, and is written to appeal to the reader.
12 points
Most of the main requirements of the Exemplary rating are present in some form. Minor work may be required to improve. TS3 may need some revising/editing.
11 points
Several of the main requirements of the Exemplary rating are missing or poorly done. It may need significant revising and/or editing.
9 points
Many of the main components of the Exemplary rating are missing or poorly done. It may need significant revising and/or editing.
0 points
Did not attempt.
Score of Topic Sentence 3,
/ 15
Rubric Total Score
Total
Score of ENGL101 Thesis and Topic Sentences (Week 3) (March 20201),
/ 100
Overall Score
Overall Score
Exemplary
90 points minimum
Accomplished
80 points minimum
Developing
70 points minimum
Beginning
60 points minimum
Did not attempt
0 points minimum
Submit Assignment
Files to submit
(0) file(s) to submit
After uploading, you must click Submit to complete the submission.
Add a File
Record Audio
Record Video
Comments
Skip Toolbars for Comments.
More Insert actions.
Format
Paragraph
Address
Preformatted
H1 – Heading 1
H2 – Heading 2
H3 – Heading 3
H4 – Heading 4
H5 – Heading 5
H6 – Heading 6
More Text actions.
More Paragraph Style actions.
Font Family
Arabic Transparent
Arial (Recommended)
Comic Sans
Courier
Ezra SIL
Georgia
SBL Hebrew
Simplified Arabic
Tahoma
Times New Roman
Traditional Arabic
Trebuchet
Verdana
돋움 (Dotum)
宋体 (Sim Sun)
細明體 (Ming Liu)
Font Size
1 (8pt)
2 (10pt)
3 (12pt)
4 (14pt)
5 (18pt)
6 (24pt)
7 (36pt)
Show All Components

Hide Assignment Information
Turnitin™
This assignment will be submitted to Turnitin™.
Instructions
Write a formal, 6 – 10 page APA research paper on the housing market crash and where we stand today. The paper should describe the scope and principal features of the field of study (such as Real Estate Broker, Agent, Appraiser, etc.), citing core theories and practices, and offer a similar explication of a related field. This means, explain how the perspective you chose relates to the field of Real Estate in general and the other areas within Real Estate.
You may write your paper from any number of perspectives:
-Appraisers and their job or role
-The lending market
-Generational effects on the housing market
-A career as a broker or sales agent or other careers in Real Estate
-Land use
-The government’s role in Real Estate
-Laws that will affect Real Estate
-Other subjects that may have affected the history and today’s situations in the Real Estate Market
A minimum of three references are required. Two must be from the APUS Library (See Course Guide for help). Wikipedia is NOT a valid Academic source. Dictionaries and encyclopedias may be used; however, they do not count towards your minimum two library references.
Style Guidelines for the paper:
Use a header on every page, including the title page. The header should be formatted according to APA guidelines.
A title page with the title, author, class, class section, professor, and date should be on the title page, centered on the page. This title page does NOT count toward your 6 to 10 page requirement.
Margins are one inch on all sides.
All content is double-spaced and left-justified.
Indent the first line of every paragraph five spaces or use the TAB key.
Do NOT leave extra space between paragraphs.
Use Times New Roman, 12-point font.
An Executive Summary is required.
References must be a separate page at the end of the paper.
Use APA style guidelines for the paper, including all references and other writing.
Submission Instructions: Post under Assignment 2, Week 6 by Sunday at 11:55 PM Eastern Time.
Please Note: All student papers are automatically submitted to Turnitin.
Rubric: See below.
Due on May 12, 2024 11:55 PM
Hide Rubrics
Rubric Name: BUSN120 Assignment 2
Print

Use the attached HW Template, which is an excel sheet to help and aid your approach to the solution. 
Show ALL calculations on additional sheet /page in the excel file. Do not edit the page that shows the examples and instructions. Add a new page and show all work there. 
Answer the questions on the provided HW Word Document. Only on there. 

Introduction: Your introductory material should set up your topic for your audience. Briefly summarize your findings (” Effects of COVID-19 on College Students “). Your introduction should not meander around the point of your paper. 
It may be more than one paragraph in length, but at some point, very early in the paper, you then need to start the substance of the paper. State your thesis in the form of a sentence or two. It should not be in the form of a question. Your thesis should be a brief statement, in your own words, that points out the significant issues about this topic that you discovered in your research. 
Body of Paper: Use subheadings (if needed) to separate aspects of your paper that support your thesis. The body of your paper should provide supporting evidence to support your thesis in a logical, fully developed manner. For each new topic that supports your overall thesis, provide a topic sentence or two which is, in effect, the thesis for that sub-topic. If you do not use subheadings, you must provide transition sentences to move your reader from one paragraph to the next. Your supporting sub-topics should address these issues: What is the significant impact of these research findings? How will they affect people? What are the benefits to people? Are there any disadvantages? These are just some questions you can answer in your paper, but feel free to add more questions you believe could be answered. 
As a research paper writer, you should synthesize the information gained from sources and weave it into a well-ordered paper, using the sources as evidence to support key points. These are how your direct quotes (In-text citations) come into your paper. 
Conclusion: Your conclusion should make “wrap up” statements about what you learned about the topic and your findings’ possible impact on people and society. Also, address any issues that may still not be resolved for you. Don’t be reluctant to address the problems that aren’t quickly resolved or have negative or ambiguous outcomes. I am looking for a thoughtful look at the topic and sharing the major significance of this issue.
Your research paper must include three direct quotes (in-text citations)—a quote from each source. Please view the Week 5 folder for in-text citations and the APA folder for more information on in-text citations. 
Page 3 or 4: Reference Page 
The final page of your research paper is your reference page. This page has all the sources you USED to write your research paper. Each source should be placed as an APA citation and in alphabetical order by the first letter of the citation. Please view the APA folder and sample research paper to understand what should be submitted for your reference page. 
Sources
Three sources in total (You may add more if you choose, but each source you use must contain an in-text citation in the body of the paper. You should have a minimum of 3 in-text citations, one from each source you use. You can use multiple in-text citations from one source, but remember each source should have at least one in-text citation.) 
Provide 3 articles ( Two that I have provided and One on your own) from a database or credible internet sources
You may use the sources from your annotated bibliography. 
Required: at least three direct quotes/paraphrases/summarizations, one from each source.