• Skip to primary navigation
  • Skip to main content
  • Skip to primary sidebar
Free ACCA & CIMA online courses from OpenTuition

Free ACCA & CIMA online courses from OpenTuition

Free Notes, Lectures, Tests and Forums for ACCA and CIMA exams

  • ACCA
  • CIMA
  • FIA
  • OBU
  • Books
  • Forums
  • Search
  • Register
  • Login
  • ACCA Forums
  • Ask ACCA Tutor
  • CIMA Forums
  • Ask CIMA Tutor
  • FIA
  • OBU
  • Buy/Sell Books
  • All Forums
  • Latest Topics

New! BPP Books for ACCA September 2022 Exams are now available, get your discount code >>

ACCA-Data Analytics

Forums › Ask ACCA Tutor Forums › ACCA Ethics and Professional Skills Module › ACCA-Data Analytics

  • This topic has 4 replies, 2 voices, and was last updated 1 year ago by Abigale.
Viewing 5 posts - 1 through 5 (of 5 total)
  • Author
    Posts
  • March 24, 2021 at 4:40 pm #615136
    Abigale
    • Topics: 2
    • Replies: 2
    • ☆

    I am new to data analytics, kindly assist in guiding me to solve this regression statistics question for which I am required to use the ANOVA table.

    Question: How much additional profit would be generated across the railway network if $250,000 were spent on automated railway investment?

    Thank you!

    March 24, 2021 at 5:40 pm #615140
    Kim Smith
    Keymaster
    • Topics: 88
    • Replies: 6090
    • ☆☆☆☆☆

    Please refer to this unit 7 thead https://opentuition.com/topic/ethics-and-professional-skills-module-unit-7

    March 30, 2021 at 3:06 pm #615518
    Abigale
    • Topics: 2
    • Replies: 2
    • ☆

    Sir, thank you for your response, but all your response is given me is reference to other responses you have given to other students, and the response is not clear on what should be done.
    The course module that I am studying does not give sufficient information on how to do the questions they have provided which is a disadvantage to the students and me in particular.
    I actually had to google to get some guidance on how to get the predicted sales for railway tickets, and I did get the answer, which is great. But the question on additional profit has been difficult to process, so far I have not seen any clear information on working out the answer.

    I would appreciate if some additional information can be provided.

    Thanks

    March 30, 2021 at 3:16 pm #615521
    Kim Smith
    Keymaster
    • Topics: 88
    • Replies: 6090
    • ☆☆☆☆☆

    You just need to read my instructions for example:

    In the section “Types of Analytics” in the course you will find a section “Predictive Analytics”. You can download the illustration BBQ sales.
    You don’t have to be able to reproduce the multiple linear regression analysis in the end of unit assessment (because it’s provided) but you do need to READ the comments that interpret the output table (e.g the “coefficients” calculated provide the regression formula: Y = a + bX1 + cX2 + dX3 … etc)

    If you “copy” the process of the Illustration (without reperforming the multiple regression itself) you should be able to solve the numerical questions (e.g. putting the values 150, 15000 etc into the formula).

    The unit also gives examples of where/why you should be sceptical or exercise caution in relying on results to answer the other end of unit questions.

    Pay attention to “units” when keying in a number-fill answer e.g. to nearest $ – no decimal or rounded to $000 for example.

    Your aim is to correctly identify the intercept value and x1 to x4 in the spreadsheet. If you work through the explanations in the illustration earlier in the unit you should be able to work these Qs out.

    It doesn’t take much time to read through my tips – and you will see that many users of the forum “get it” when they invest the time in working through the illustration.

    March 30, 2021 at 10:15 pm #615547
    Abigale
    • Topics: 2
    • Replies: 2
    • ☆

    Thank you for the added information, I will try to use the info. you provided to work out the answer.

    Thanks

  • Author
    Posts
Viewing 5 posts - 1 through 5 (of 5 total)
  • You must be logged in to reply to this topic.
Log In

Primary Sidebar

Donate

If you have benefited from OpenTuition please donate.

Specially for OpenTuition students

20% off BPP Books

Get BPP Discount Code

Latest comments

  • Manuga on ACCA AB Chapter 18 – The nature of communication – Questions
  • Manuga on MA Chapter 17 Questions Budgeting
  • Manuga on Budgeting part 4 – Cash Budgets – ACCA Management Accounting (MA)
  • John Moffat on MA Chapter 2 Questions Sources of Data
  • John Moffat on The Management Accountant’s Profit Statement – Marginal Costing – ACCA Management Accounting (MA)

Copyright © 2022 · Support · Contact · Advertising · OpenLicense · About · Sitemap · Comments · Log in


We use cookies to show you relevant advertising, find out more: Privacy Policy · Cookie Policy