• 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
  • Ask AI
  • Search
  • Register
  • Login
  • ACCA Forums
  • Ask ACCA Tutor
  • CIMA Forums
  • Ask CIMA Tutor
  • FIA
  • OBU
  • Buy/Sell Books
  • All Forums
  • Latest Topics

20% off ACCA & CIMA Books

OpenTuition recommends the new interactive BPP books for March and June 2025 exams.
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 4 years ago by Abigale.
Viewing 5 posts - 1 through 5 (of 5 total)
  • Author
    Posts
  • March 24, 2021 at 4:40 pm #615136
    Abigale
    Member
    • 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: 133
    • Replies: 8289
    • ☆☆☆☆☆

    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
    Member
    • 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: 133
    • Replies: 8289
    • ☆☆☆☆☆

    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
    Member
    • 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 our materials, please donate

ACCA News:

ACCA My Exam Performance for non-variant

Applied Skills exams is available NOW

ACCA Options:  “Read the Mind of the Marker” articles

Subscribe to ACCA’s Student Accountant Direct

ACCA CBE 2025 Exams

How was your exam, and what was the exam result?

BT CBE exam was.. | MA CBE exam was..
FA CBE exam was.. | LW CBE exam was..

Donate

If you have benefited from OpenTuition please donate.

PQ Magazine

Latest Comments

  • Ken Garrett on The nature and structure of organisations – ACCA Paper BT
  • Ark1 on The nature and structure of organisations – ACCA Paper BT
  • zsotuminu on The weighted average cost of capital (WACC) – ACCA Financial Management (FM)
  • Kim Smith on What is Assurance? – ACCA Audit and Assurance (AA)
  • Kim Smith on AA Chapter 17 Questions

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