Needing Direction: Showing Progress Over Time with Small Numbers

In summary: I have sets of number: week 9 27 turned in 25 good 2 bad = 93% & 7% week 10 56 turned in 55 good 1 bad = 98% & 2% week 11 75 turned in 74 good 1 bad = 99% & 1% week 12 6 turned in 5 good 1 bad
  • #1
SamSmith1
2
0
Needing Direction
I have sets of number:
week 9 27 turned in 25 good 2 bad = 93% & 7%
week 10 56 turned in 55 good 1 bad = 98% & 2%
week 11 75 turned in 74 good 1 bad = 99% & 1%
week 12 6 turned in 5 good 1 bad = 83% & 17%

In a graph by % of total it looks like the bad went up drastically - however is was the same number "1"

How do I show a graph more meaningfully over time, when it's the total number that is affecting the % and not the result of 1

Should I look into ratio's of grand totals over time, or statistical significance, or difference from week to week, weighted numbers based on what? or is this the best that can be done?
 
Mathematics news on Phys.org
  • #2
Welcome to PF. :smile:

Maybe try using a Bargraph plot by week #, with different colors for Good/Bad (maybe Green/Red?) and the height of each week's bar is the Total. That way the relationships will stand out better.

BTW, is this a schoolwork question or is it for your work?
 
  • Like
Likes mfb
  • #3
berkeman said:
Welcome to PF. :smile:

Maybe try using a Bargraph plot by week #, with different colors for Good/Bad (maybe Green/Red?) and the height of each week's bar is the Total. That way the relationships will stand out better.
That's a good idea. But in this case, will the bad 1 would even show up on an axis that goes up to 75?
 
  • Like
Likes berkeman
  • #4
FactChecker said:
That's a good idea. But in this case, will the bad 1 would even show up on an axis that goes up to 75?
Excellent question. I considered posting the Excel plot, but if this is schoolwork, I'd have to give myself an infraction for "too much help". And I don't need any more of those! :wink:
 
  • Like
Likes FactChecker
  • #5
berkeman said:
Excellent question. I considered posting the Excel plot, but if this is schoolwork, I'd have to give myself an infraction for "too much help". And I don't need any more of those! :wink:
Good point. And I am not sure that there is anything to advise other than to try different plots and see what works best. Maybe two plots, one of the percentages and one of the numbers.
 
  • #6
Yeah, and what does "turned in" mean? In school, if you don't turn in your homework, that counts toward the "bad" number. Why is the number of things involved changing so much week-to-week.

We need the OP to respond before we waste more time on this question, IMO.
 
  • Like
Likes FactChecker
  • #7
Also, who's the audience? You might take different approaches with experienced statisticians from with management types.
 
  • #8
Ibix said:
management types
:wideeyed:
 
  • #9
Maybe a logarythmic vertical scalebar graph? Very small numbers would be proportionately emphasized. Large, absolute values would be de-emphed.
 
  • Like
Likes FactChecker
  • #10
berkeman said:
:wideeyed:
Some of my management is frighteningly competent at this kind of thing. Some of 'em, not so much...
 
  • #11
berkeman said:
and what does "turned in" mean? In school, if you don't turn in your homework, that counts toward the "bad" number.
Only if its a mandatory assignment. If it were for bonus marks or some such then sample size over time is variable.

It's a good point you raise. If it is a voluntary assignment, then total is not the right context. If only six chose to hand in, that's not really important, and that 17% jump in "bad" is significant.
 
  • #12
I keep a "Double Secret Probation Penalty List" for students who don't turn in their "bonus" assignments. Just saying...

1648676037488.png

https://www.hollywoodreporter.com/l...t-now-john-belushi-tim-matheson-more-1126335/
 
  • #13
DaveC426913 said:
Maybe a logarythmic vertical scalebar graph? Very small numbers would be proportionately emphasized. Large, absolute values would be de-emphed.
Then you can't stack them, but two bars next to each other (bad/good) would work.

If the audience has some experience with statistics then you can plot the percentage but indicate a 90% confidence interval in the graph. That will be very large for weeks with low totals.
 
  • #14
I would use a stacked column, labeling numbers and %. Can add a bullet on the low number of events in the last week (perhaps something also that if the bad prob is 1% then there is around a 6% chance of getting at least one bad in 6 tries)
 
  • #15
SamSmith1 said:
Needing Direction
I have sets of number:
week 9 27 turned in 25 good 2 bad = 93% & 7%
week 10 56 turned in 55 good 1 bad = 98% & 2%
week 11 75 turned in 74 good 1 bad = 99% & 1%
week 12 6 turned in 5 good 1 bad = 83% & 17%

In a graph by % of total it looks like the bad went up drastically - however is was the same number "1"

How do I show a graph more meaningfully over time, when it's the total number that is affecting the % and not the result of 1

Should I look into ratio's of grand totals over time, or statistical significance, or difference from week to week, weighted numbers based on what? or is this the best that can be done?

Thanks everyone for your help. 4/4/22
 
  • #16
SamSmith1 said:
Thanks everyone for your help. 4/4/22

:mad: :mad: :mad:

1649107174167.png

https://xkcd.com/979/

How many times have I Googled a programming problem, found someone else asked it, and then responded to their own question with "Thanks, I figured it out." :headbang: :headbang: :headbang: :headbang: :headbang:
 
  • Like
Likes FactChecker
  • #17
SamSmith1 said:
Thanks everyone for your help. 4/4/22
So does that mean you found a solution? Can you post what you did?

And BTW, was this a problem for schoolwork?

And... why did you append the date to your latest reply?
 
  • #18
berkeman said:
And... why did you append the date to your latest reply?
Indeed. This is the second reference I've seen to 4:4. No idea what the significance is but I think it's something woo.
 

1. What is the purpose of showing progress over time with small numbers?

The purpose of showing progress over time with small numbers is to track and analyze changes or improvements in a specific area or set of data. This can provide valuable insights and help make informed decisions.

2. How do you determine the appropriate time frame for showing progress with small numbers?

The appropriate time frame for showing progress with small numbers will depend on the specific goals and objectives of the study or analysis. It is important to consider the frequency of data collection and the rate of change in the data to determine the most effective time frame.

3. What are some effective ways to visualize progress over time with small numbers?

Some effective ways to visualize progress over time with small numbers include line graphs, bar graphs, and scatter plots. These types of graphs can help illustrate trends and patterns in the data over time.

4. How can showing progress over time with small numbers be used in decision-making?

Showing progress over time with small numbers can provide valuable information for decision-making by helping to identify areas of improvement or success. It can also help track the effectiveness of interventions or strategies and inform future plans.

5. What are some potential challenges when showing progress over time with small numbers?

Some potential challenges when showing progress over time with small numbers include the risk of misinterpreting the data, difficulties in collecting accurate and consistent data, and the need for careful consideration of external factors that may influence the data.

Similar threads

  • Engineering and Comp Sci Homework Help
Replies
3
Views
2K
Replies
3
Views
1K
  • STEM Academic Advising
Replies
9
Views
1K
Replies
4
Views
1K
  • Engineering and Comp Sci Homework Help
Replies
6
Views
2K
  • General Discussion
Replies
18
Views
11K
  • General Math
Replies
3
Views
2K
  • Programming and Computer Science
Replies
1
Views
2K
  • Engineering and Comp Sci Homework Help
Replies
12
Views
2K
Replies
8
Views
2K
Back
Top