Question description:
This user has given permission to use the problem statement for this
blog.
Compute the weighted average of students score from a spreadsheet using different weight for each category of marks
Solved by G. E. in 20 mins
This is the chat thread from the real Excelchat help session. It contains no private user
information.
Excelchat Expert
13/12/2017 - 07:43
Hello!
Excelchat Expert
13/12/2017 - 07:43
welcome to excelchat
Excelchat Expert
13/12/2017 - 07:43
can i see the data on which you want this?
User
13/12/2017 - 07:43
hey
User
13/12/2017 - 07:44
just a random example
User
13/12/2017 - 07:44
based on that question
User
13/12/2017 - 07:44
as simple as you can make it
Excelchat Expert
13/12/2017 - 07:44
ok can you create a dummy data for me
Excelchat Expert
13/12/2017 - 07:44
ok i got you
Excelchat Expert
13/12/2017 - 07:44
i will create that
User
13/12/2017 - 07:45
thank you
Excelchat Expert
13/12/2017 - 07:45
weight for each category of marks are?
User
13/12/2017 - 07:46
yeh
User
13/12/2017 - 07:46
is this all free
User
13/12/2017 - 07:46
i can do this again
Excelchat Expert
13/12/2017 - 07:46
yes you can do this again
Excelchat Expert
13/12/2017 - 07:47
but there are three free sessions
Excelchat Expert
13/12/2017 - 07:47
after that there is charges which are listed there
User
13/12/2017 - 07:47
alright
Excelchat Expert
13/12/2017 - 07:48
can you tell me weight for categories?
User
13/12/2017 - 07:48
idk what the categories is
User
13/12/2017 - 07:48
its based on school
Excelchat Expert
13/12/2017 - 07:48
ok
User
13/12/2017 - 07:48
testst
User
13/12/2017 - 07:48
getting
User
13/12/2017 - 07:48
weighted avg
Excelchat Expert
13/12/2017 - 07:49
lets take is as 20 to 50 and 50 to 100
Excelchat Expert
13/12/2017 - 07:49
and 10 to 20
Excelchat Expert
13/12/2017 - 07:50
sorry 0 to 20
User
13/12/2017 - 07:53
Using the Logical IF function, compute the tax on income with two (2) tax brackets.
User
13/12/2017 - 07:53
can u show that next
Excelchat Expert
13/12/2017 - 07:54
yes sure
Excelchat Expert
13/12/2017 - 07:54
weighted average is done
User
13/12/2017 - 07:54
i took
User
13/12/2017 - 07:54
pic
User
13/12/2017 - 07:54
thank you
Excelchat Expert
13/12/2017 - 07:54
your most welcome
Excelchat Expert
13/12/2017 - 07:55
you want to calculate tax right?
User
13/12/2017 - 07:55
using if function'
Excelchat Expert
13/12/2017 - 07:55
ok
User
13/12/2017 - 07:55
Using the Logical IF function, compute the tax on income with two (2) tax brackets.
Excelchat Expert
13/12/2017 - 07:55
ok sure
User
13/12/2017 - 07:58
so for the first question I'm just adding weight together and multiplying marks by weight
User
13/12/2017 - 07:58
then diving sum of marks times weight by the weight totoal
Excelchat Expert
13/12/2017 - 07:59
can you see the tax working?
User
13/12/2017 - 07:59
yeh
User
13/12/2017 - 07:59
it said error for first one
User
13/12/2017 - 07:59
but shows
Excelchat Expert
13/12/2017 - 08:00
so for the first question I'm just adding weight together and multiplying marks by weight," exactly"
Excelchat Expert
13/12/2017 - 08:00
then diving sum of marks times weight by the weight totoal, yes
Excelchat Expert
13/12/2017 - 08:00
now its not showing error
User
13/12/2017 - 08:00
its not showing error
User
13/12/2017 - 08:00
but still lost for the 2nd question
Excelchat Expert
13/12/2017 - 08:01
in 2nd question i have added 2 slab rates
Excelchat Expert
13/12/2017 - 08:01
where if income is less then 250000 then nil tax
Excelchat Expert
13/12/2017 - 08:01
250000 to 500000 20%
Excelchat Expert
13/12/2017 - 08:01
and above that its 30%
Excelchat Expert
13/12/2017 - 08:02
its like that
Excelchat Expert
13/12/2017 - 08:02
got it?
User
13/12/2017 - 08:02
it has to be less
User
13/12/2017 - 08:02
then 25000
User
13/12/2017 - 08:02
in order to gain tax
Excelchat Expert
13/12/2017 - 08:02
yes
User
13/12/2017 - 08:03
thank you
User
13/12/2017 - 08:03
ill try to figure out
Excelchat Expert
13/12/2017 - 08:03
do you have further queries regarding this question?
This is the output file from the real Excelchat help session:
This is an example of the expert help you can get. It contains no private user
information.