Need Excel help identifying trends and anomalies

[GreenFly]

Hi,

I just started a new job at a manufacturing company. The plant that I work at has 32 production units. Each unit is given a daily score on how well it performs. The data is extremely erratic. My boss asked me to analyze it and see if there is a trend to the data, so for example after 4 days of less than average is the 5th day average or above average? What is the probability of after 3 below average days that we have an average day? This will help us determine a schedule for cleaning, maintenance, etc. The best analogy I could use would be the stock market, after 3 down days what is the probability the 4th day will be up based on the data set.

Can someone help me with how to do this analysis? Much appreciated. I uploaded a set of fake data for an example.

all_teams.xlsx
	A	B
2	Machine	Score
3	abl	35
4	abl	35
5	abl	45
6	abl	45
7	abl	45
8	abl	5
9	abl	0
10	abl	20
11	abl	5
12	abl	40
13	abl	10
14	abl	45
15	abl	40
16	abl	10
17	abl	5
18	abl	50
19	abl	5
20	abl	10
21	abl	50
22	abl	10
23	abl	5
24	czv	15
25	czv	5
26	czv	45
27	czv	10
28	czv	15
29	czv	0
30	czv	10
31	czv	10
32	czv	0
33	czv	40
34	czv	25
35	czv	10
36	czv	40
37	czv	40
38	czv	10
39	czv	20
40	czv	10
41	czv	50
42	czv	5
43	czv	45
44	czv	15
45	zxc	5
46	zxc	35
47	zxc	35
48	zxc	40
49	zxc	0
50	zxc	45
51	zxc	40
52	zxc	10
53	zxc	0
54	zxc	5
55	zxc	10
56	zxc	0
57	zxc	20
58	zxc	5
59	zxc	10
60	zxc	5
61	zxc	40
62	zxc	10
63	zxc	10
64	zxc	5
65	zxc	5
Sheet2