0
$\begingroup$ 
5 star    128
4 star    17
3 star    10
2 star    2
1 star    14

Average stars 4.42

How many more 5 stars would I need to get Average Stars to 4.45 or 4.47 etc.

So what I tried was using SUMPRODUCT in Excel but I am approaching this wrong. First of all I cannot achieve the current number 4.42 because of my incorrect approach.

I would like to be able to change the variables at my discretion and see the outcome

how would I continue?

$\endgroup$
5
  • $\begingroup$ Let $n$ number of $5$ starts are needed So, the average will be $$=\frac{128+17+10+2+14+128\cdot n}{n+5}$$ $\endgroup$
    – lab bhattacharjee
    Commented Jul 8, 2013 at 15:28
  • $\begingroup$ @labbhattacharjee thanks, I need this to return a number like 4.42 for a visual aid, this doesn't give me an indication of what the current average star is when I change variables, this is very close though $\endgroup$
    – CQM
    Commented Jul 8, 2013 at 15:34
  • 1
    $\begingroup$ @labbhattacharjee: No, the average is not that. $\endgroup$
    – Ross Millikan
    Commented Jul 8, 2013 at 15:56
  • $\begingroup$ @RossMillikan, it depends on the context. $\endgroup$
    – lab bhattacharjee
    Commented Jul 8, 2013 at 16:09
  • $\begingroup$ @labbhattacharjee: the $128$ votes need to be weighted by $5$ etc. $\endgroup$
    – Ross Millikan
    Commented Jul 8, 2013 at 16:30

1 Answer 1

Reset to default
2
$\begingroup$

Define $S=128 \cdot 5 + 17 \cdot 4 + 10 \cdot 3 + 2 \cdot 2 + 14 \cdot 1$ and $N=128+17+10+2+14$ Your current average is $A=\frac SN=\frac {128 \cdot 5 + 17 \cdot 4 + 10 \cdot 3 + 2 \cdot 2 + 14 \cdot 1}{128+17+10+2+14}$. If you want your average to be $A'$ from the addition of $n\ 5$'s, you need $A'=\frac {S+5n}{N+n}$. You can solve this for $n$ as all the other values are given. $A'(N+n)=S+5n, n=\frac {A'N-S}{5-A'}$

$\endgroup$
1
  • $\begingroup$ yes, this worked for me, thank you $\endgroup$
    – CQM
    Commented Jul 8, 2013 at 16:44

You must log in to answer this question.

Not the answer you're looking for? Browse other questions tagged .