Category: Analytics

I have attached the Pivot table analysis I have created to go along with this paper. It does not need to be attached. Sheet 1 has the pivot tables and associated charts for the data  set.
Mastery Assignment: Pivot Analysis with Microsoft Analysis
In this
exercise we will be using Microsoft Excel for a Pivot analysis. Open the
spreadsheet (Mastery Assignment – Dataset) and familiarize yourself with the
data.
1.      Interpret
the data:
○  
What kind of data is it and what can
it be used for?
○  
Explain the purpose of each column, in
particular of the columns including measures (such as “Order_Price_Total”).
2.      Imagine
the following scenario: You are hired as the new assistant to the executive
board. You are asked to prepare a meeting for tomorrow, in which the board will
discuss the following business questions:
○  
How has sales developed in 2009 –
compared to the year before?
○  
Who are our top 10 customers in 2009?
○  
What are our top 10 products in 2009?
○  
How are sales distributed over the regions?
Requirements
for Executive Summary (Paper):
Prepare a quality, substantive paper that
addresses the objectives of the assignment and the expectations set forth
in the grading rubric.
A minimum of 500 words (excluding the title
page and references) is required. 
Cite at least two credible sources (including
course materials) written within the past 5 years.
Use APA style:
Refer to APA Resources
and the Online Tutoring Center resources in Academic Resources (see SC College
Resources Links) for guidance on writing style and page and citation formatting

Automotive brand HONDA
Requires R STUDIO analytics 
This is what I need the PowerPoint and Script about: 
Visualize and interpret the differences in (a) Method of Payment, (c) Insurance and (d) Age within each region that your brand is serving. You can explore other options. 
Attached in all the files is what is needed to use in order to answer   the questions above. 
5 powerpoint slides and a script need 4 minutes of talking. 

Project Planning/Timeline
Submit a word document identifying key milestones for the project such as data collection, data review, data analysis etc., and create time lines to complete them. Make sure you meet the expectation for the duration of the project to be completed by Week 15.
Paper should include the following sections:
Section I: Introduction/Background/Problem Statement
Section II: Body
Literature Review
Data
Methods
Analysis (three stages)
Results
Section III: Conclusion/Discussion
Appendices

Discuss your theoretical framework you plan to use for your paper.  What is a theoretical framework and how does it apply to your project? Review the theoretical frameworks put forward by your classmates and offer suggestions to assist them with their projects.  Discuss feedback given to you.

You must be proficient in using software SIMUL8. Use the software to solve a Data analysis/business analysis case. 
The main body of the
report (the executive summary) should not exceed 6 typed pages of A4
paper (11
point font, single spacing).
You should also include a technical appendix with a maximum length of 8
pages.    Furthermore details are included in the 
Simulation Project 2024.docx . 

ImDownWithThis is a (fictitious) AI-driven app that helps people manage their weight. It operates on a monthly subscription basis (the company calls subscribers members) where the subscription includes an (AI generated) expert assessment, guidance, tips and education, a digitally connected scale and unlimited virtual coaching. Through various behavioral modification techniques, the company encourages members to weigh in daily and check in with their virtual coach at least daily. By connecting to member’s scale, the company reads the weight of all members who weigh in. It then uses this information and the contents of previous coaching sessions to guide a virtual assistant in chat sessions with members. The company recently incorporated ChatGTP technology into its virtual assistant.
When members join, they fill out a detailed assessment that supplies personal and demographic information about themselves including age, gender, marital status, height and weight, etc. The company computes four proprietary scores for each member: 
1. Diet: a measure of the member’s eating habits.
2. Engagement: a measure of how engaged the member is in ImDownWithThis’s programs and coaching.
3. Success: a measure of several member attributes including weight loss and maintenance and the member’s desired goals.
4. Bliss: a measure of the member’s overall happiness with themself, and their life based on proprietary algorithms the company applies to the virtual chat sessions. 
These scores are continuously evaluated and updated, although the supplied data for this exercise is at single points in time (there is no longitudinal data analysis in this case study).
Deliverables: Perform regression analysis to:
@Identify correlations in marital status and scores (bliss, diet, success, and engagement edit 100+to 99)
@ Identify correlations in marital status and children and scores(bliss, diet, success, and engagement edit 100+to 99)
@ Identify trends in the scores and length of membership
NOTE: Scores comprise  of (bliss score, diet score, success score, and engagement edit 100+to 99 score)
Pls explain the findings

Week8 HW: Chp7 Hypothesis Testing Part2(6 questions in total)
Portal Link:  https://www.cwu.edu/about/offices/information-services/enterprise-application-services/mycwu.html
User ID:  Password:  Tb-952795279527
Navigation Steps:   need to go through authenticator

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.

To make this assignment a bit easier, all I am looking for in the paper is information about how managers are using analytics and it what areas and programs they are using them.  Obviously, you will have to expound on that to get to 750 words, but that should make it easier. 
§  https://www.datasciencecentral.com/
§  http://analytics-magazine.org/digital-editions/
§  http://dssresources.com/
§  APA format is required for this paper

The assignment requires that you analyse a data set, interpret, and draw conclusions from your analysis,
and then convey your conclusions in a written report.
The excel file is attached and the instructions file is also attached go through the instruction file carefully and their is a template and rubrik attached as well. Please reach out if there is any problem with any techniques that need to be used in the analysis