2.Task 1
You are asked to carry out a study on behalf of a business analytics specialised consultancy on a subsample
...
on a subsample of weekly data from Randall’s Supermarket, one of the biggest in the UK. Randall’s marketing management team wishes to identify trends and patterns in a sample of weekly data collected for a number of their loyalty cardholders during a 26-week period. The data includes information on the customers’ gender, age, shopping frequency per week and shopping basket price. Randall’s operates two different types of stores (convenient stores and superstores) but they also sell to customers via an online shopping platform. The collected data are from all three different types of stores. Finally, the data provides information on the consistency of the customer’s shopping basket regarding the type of products purchased. These can vary from value products, to brand as well as the supermarket’s own high-quality product series Randall’s Top. As a business analyst you are required to analyse those data, make any necessary modifications in order to determine whether for any single customer it is possible to predict the value of their shopping basket.
Randall’s marketing management team is only interested in identifying whether the spending of the potential customer will fall in one of three possible groups including:
• Low spender (shopping basket value of £25 or less)
• Medium Spender (shopping basket value between £25.01 and £70) and
• High spenders (shopping basket greater than £70)
For the purpose of your analysis you are provided with the data set Randall’s.xls. You have to decide, which method is appropriate to apply for the problem under consideration and undertake the necessary analysis. Once you have completed this analysis, write a report for the Randall’s marketing management team summarising your findings but also describing all necessary steps undertaken in the analysis. The manager is a competent business analyst himself/herself so the report can include technical terms, although you should not exceed five pages. Screenshots and supporting materials can be included in the appendix.
Requirements
After completing your analysis, you should submit a report that consists of two parts. Part A being a non-technical summary of your findings and Part B a detailed report of the analysis undertaken with more details.
Part A: A short report for the Head of Randall’s Marketing Management (20 per cent). This should briefly explain the aim of the project, a clear summary and justification of the methods considered as well as an overview of the results.
Although, the Head of Randall’s Marketing Management team who will receive this summary is a competent business analytics practitioner, the majority of the other team members have little knowledge of statistical modelling and want to know nothing about the technical and statistical underpinning of the techniques used in this analysis. This report should be no more than two sides of A4 including graphs, tables, etc. In this report you should include all the objectives of this analysis, summary of data and results as well as your recommendations (if any).
Part B: A technical report on the various stages of the analysis (80 per cent).
The analysis should be carried out using the range of analytics tools discussed:
• SPSS Statistics
Ensure that the exercise references:
• Binary and multinomial logistic regression
• Linear vs Logistic regression
• Logit Model with odds Ratio
• Co-efficients and Chi Squared
• MLR co-efficients
• Assessing usefulness of MLR model
• Interpreting a model
• Assessing over-all model fit with Psuedo R-Squared measures
• Classification accuracy (Hit Ratio)
• Wald Statistic
• Odd ratio exp(B)
• Ratio of the probability of an event happening vs not happening
• Ratio of the odds after a unit change in the predictor to the original odds
• Assumptions
• Residuals analysis
• Cook’s distance
• DfBeta
• Adequacy (with variance inflation factor VIF and tolerance statistic)
• Outliers and influential points cannot just be removed. We need to check them (typo? – unusual data?)
• Check for multicollinearity
• Parsimony
Write a short and concise report to explain the technical detail of what you have done for each step of the analysis.
The report should also cover the following information:
• Any type of analysis that might be useful and check whether the main assumptions behind the analyses do not hold or cannot be
• Give evidence of the understanding of the statistical tools that you are using. For example, comment on the model selection procedure and the coefficient interpretation, e.g. comment on the interpretation of the logistic regression coefficients if such a method is used and provide an example of
• Conclusions and explanation, in non-technical terms, of the main points
View More
3.Hello I have two problems to solve the subject is Quantitative Methods for Decision-Making
Problem 2
After graduating from AUD, Salman plans
...
m 2
After graduating from AUD, Salman plans to start a book publishing company in the Media City. He did some research and found that the printer will cost Dh 230,000. He estimated that the variable cost per book is Dh 170 and the selling price is Dh 390.
a. How many books must he sell to break even? Also calculate the breakeven in dirham.
b. In addition to the costs given above, if he wants to pay himself a salary of Dh 15,400 per year, what is her breakeven point in units and dirham?
c. In the first three months of his business, he sold 400 books. Suddenly the printer breaks down. He spent Dh 25000 to fix the printer. In addition to 400 books sold, how many more books she should sell to breakeven? Assume that this part of the question is independent, and she does not draw any salary.
Problem 8
A furniture store makes tables and chairs from plywood and glass. The store has 30 units of plywood, 24 units of glass. Each table requires 7 units of plywood three units of glass, whereas each chair requires three units of plywood and two units of glass. The demand for chairs is between 2 and 4. The ratio between the table and chair is at least 1 to 2. A table earns $225 in profit and a chair, $145. The store also wants a minimum profit of $5000. The store wants to determine the number of tables and chairs to make in order to maximize profit. Formulate a linear programming model for this problem
View More
5.After a dreary day of rain, the sun peeks through the clouds and a rainbow forms. You notice the rainbow
...
nbow is the shape of a parabola.
The equation for this parabola is y = -x2 + 36.
Graph of a parabola opening down at the vertex 0 comma 36 crossing the x–axis at negative 6 comma 0 and 6 comma 0.
Create a table of values for a linear function. A drone is in the distance, flying upward in a straight line. It intersects the rainbow at two points. Choose the points where your drone intersects the parabola and create a table of at least four values for the function. Remember to include the two points of intersection in your table.
Analyze the two functions. Answer the following reflection questions in complete sentences.
What is the domain and range of the rainbow? Explain what the domain and range represent. Do all of the values make sense in this situation? Why or why not?
What are the x- and y-intercepts of the rainbow? Explain what each intercept represents.
Is the linear function you created positive or negative? Explain.
What are the solutions or solution to the system of equations created? Explain what it or they represent.
View More
10.I am taking Linear Algebra for the first time. My course follows the textbook Linear Algebra 4th edition by
...
ition by Arnold J. Insel, Lawrence E. Spence, and Stephen H. Friedberg. I feel like the textbook lacks explanation considering this is my first exposure to linear algebra. At this point in the semester, I feel like I have a good idea of the concepts and how to represent them (e.g. I understand and can visualize what is happening in space) because I've spent a lot of time learning from alternative resources. What I am having trouble with now is when I go back to the book, I can follow the examples to an extent, but there are computations that aren't explained and I don't know where they are coming from. Moreover, and more importantly, I don't know how to approach the assignment questions at all.
View More
11.I Need a tutor who is experienced in teaching Core plus math course 3. Need explanation and practice of question
...
of question from the chapter. If the student shows progress it is very likely that we will need at least weekly tutoring.
The Topic is inequalities and linear programming.
Please find attached the material:
-cmic unit is the chapter they are studying,
- Core linear programming is questions on the chapter.
- U2 Exam. will need help in answering the questions:
Please read the material carefully and tell me how much time is needed to make the best use of this time to explain the and go over the examples.
How long it takes to have the student review her work with you.
View More