- 5OS02: You are a learning and development consultant who has been contracted by a relatively large organisation: Advances in digital learning and development Report, UK
- Requires you to create a two-part electronic poster, drawn from your group work on an ongoing: Operating Department Practice Case Study, WGU, UK
- 6HW153: Analysis requires you to investigate the management of a patient with an undifferentiated minor illness that you have experienced in practice: Minor Il lness Theory into Practice for Emergency Practitioners Case Study, UOW, UK
- This case study documents a collaboration between the Global Fund for Community Foundations and the Coady International Institute: Public Health Case Study, QUB, UK
- Evaluate the sociological explanations related to your life chances and Explain the relationship between your health: Health and social care Case Study, UOG, UK
- 7HR02: Resourcing and talent management to sustain success Case Study, WLC, UK
- HHH3010: You have been asked by an associate mentor to assist in mentoring a student and The student is struggling to achieve: Practice Education for Paramedics Case Study, UOH, UK
- CGRM4000: You are required to write a report to a corporate board summarising your views on corporate governance sustainability: Corporate Governance Sustainability and Ethics Case Study, KBS, UK
- Singapore’s political system is a parliamentary democracy It has a very similar setup to that of the United Kingdom: Political Systems Case Study, UoWL, UK
- List your variables for the system put them into linked pairs and Please provide the list of variables and pairs: Business Studies Case Study, UOWL, UK
- Explain that normal budgeted expenditure covers 12 months of day-to-day expenditure, not long-term capital investment: MBA with a Specialism in Finance Case Study, HWU, UK
- Wildland Park is a visitor attraction in Dorset, England, on the grounds of Casterbridge Hall, a stately home near Axminster: International Marketing Case Study, LSBU, UK
- 5CO02: Your company has been invited to submit a briefing paper for a regional People Practice event that will share insights: Evidence-Based Practice Case Study, BU, UK
- CT7155: Plan, design, and implement the International Travel Agency switched network as shown in the diagram and described below: Switched Networks Case Study, LMU, UK
- Explain why you consider each example as a market anomaly/market bubble: Financial Behaviour Case Study, UOL, UK
- Advise how you would have planned the project given your choice of life cycle and methodology: Project Management Techniques Case Study, UON, UK
- 7ENT1127: Evaluate quantitative modeling concepts for problem-solving and decision-making in a logistics context: Operations Research and Logistics Case Study, UOH, UK
- Define the ones moods and concepts relating to the study of human behavior in the workplace: Managing People case Study, UOS, UK
- ADN402: Describe and analyze the long-term support needs of people living with long-term conditions: Long Term Conditions And Multi-Morbidity Case study, SU, UK
- Describe and explain the historical ideological and regional context that led to the establishment of that system: Political Systems Case study, UOS, UK
Ffynone House is a Private Secondary School located in Swansea, Wales and They have contacted Buxton Analytics: Business Analytics Case Study, SU, UK
| University | Swansea University (SU) |
| Subject | Business Analytics |
Case Study
Ffynone House is a Private Secondary School located in Swansea, Wales. They have contacted Buxton Analytics to create an analysis report on students’ Welsh scores from 2014-2021. As class sizes vary the number of observations for each year also varies. Ffynone House has collected a large amount of data on a number of students’ attributes over the course of their time at the school. This data along with the grades each student received for their Welsh tests at three different test points.
Questions
1. Using the Glossary table within the provided excel file determine the type of
data used by each variable: Time, Discrete Numerical, Continuous Numerical,
Ordinal Categorical, Binary, Nominal Categorical
2. Using appropriate measures of descriptive analytics analyze the numerical and categorical variables comparing them in the graphical or tabular format against G1, G2, and G3.
3. Complete a multiple regression with G3 as the dependent variable with all
relevant variables as independent variables.
a. Undertake a correlation to determine which variables are correlated with each other.
i. Which variables are highly correlated with G3?
ii. Are there any independent variables that are highly correlated
with each other?
b. Convert categorical variables to dummy variables if you are including
them in the analysis
c. Undertake the multiple regression
d. Determine from the multiple regression which variables are insignificant
e. Rerun the regression with the insignificant variables removed
f. Provide an interpretation of the final regression model remember to
discuss any issues of multicollinearity.
4. You are expected to create and compare two forecasting methods with G3 as the dependent variable.
a. In order to successfully achieve this you will need to average the grades
for all students in each year group before undertaking your forecast.
b. Choose from the following 4 forecasting methods and remember to make
sure your models are appropriately adjusted for trends and seasonality
where required.
i. Method 1 – Naïve Forecast
ii. Method 2 – Moving Averages Forecast
iii. Method 3 – Exponential Smoothing Forecast
iv. Method 4 – Regression based Forecast
c. The average accuracy measures for each model also need to be
calculated.
5. After completing a thorough analysis of the Welsh scores the teachers at
Ffynone House would like to know:
a. What four variables have the most impact on student Welsh Scores
(G3)? Please explain your answer in reference to the above questions.
b. Based on the correlation, do the same factors that impact G3 also
appear to influence G1 and G2?
c. What forecasting method best predicts the final grade across the three years?
Do You Need Assignment of This Question
Answer
