Question

Ethics & Professional Skills

Hi,

I'm appearing Unit 7, End of Unit Assessment (No 11), question on "Beeland".

However, i'm stuck on this question on railway station network data, X with independent variables and Y with dependent variables. The question further provides an excel sheet and ANOVA table.

Since we are required to use the excel table to answer the questions, I request your inputs on the following issues -

1. where is the data tab?
2. where is the data analysis tab?
3. where is regression input table?
4. where do i find the drop down button from where I need to select regression?

The excel which i downloaded is below. I cannot find details above.

Many Thanks,...

Answer 1

Hi, I too am stuck on this assesment but I think I have got a bit further then you :)
Along the top of the excel document there is the word Data. That is Q1.
Then to the far right hand side should be analysis tools. If Data Analysis is not under that then you need to add it by selecting Analysis Tools. The rest should follow the instructions as on the first page. Good Luck