Your manager has provided you with the Microsoft 365 Survey Data Set [XLXS] Download Microsoft 365 Survey Data Set [XLXS], which includes the survey data collected on Microsoft 365 used across three other organizations. Using this data set, complete the following:Download the Microsoft 365 Survey Data Set [XLXS] Download Microsoft 365 Survey Data Set [XLXS]Excel file and save it to OneDrive. Copy the data into a new tab in the file, and in the new tab, clean the data by removing duplicate data and empty cells, identifying and correcting errors, fixing formatting and inconsistencies, and running spellcheck.Using another new tab in the Excel file, create at least two visualizations of the data by identifying specific trends and insights that point to the relationship between using Microsoft 365 tools and the effect on business productivity and team-based collaboration.See Chapters 7 and 8 in the Data Visualization textbook for examples of charts that help visualize comparisons and parts of a whole.In a Word document, write a 3-4 page summary in which you:Draw conclusions from the trends and insights that surfaced when you analyzed the data. Specifically, what does the data tell you about the relationship between using Microsoft 365 tools and the effect on business productivity and team-based collaboration? Also, include any questions that arise from the data.Justify your choice of visualizations to represent the data by explaining why you chose each of the visualizations. Your explanation should include why those visuals were most appropriate for the data and how those visuals support the conclusions you drew from the data.Keep in mind this summary is for your manager, who may share it with other stakeholders in the company. Your writing should be professional in nature. Include an introductory paragraph that states the purpose of the summary and a conclusion paragraph that ties everything together. The summary should also be free of grammatical, punctuation, and spelling errors.Save both the Excel file and the Word document in OneDrive. Use OneDrive to work together on the documents and prepare them for submission. Each of you should submit the same Excel file and Word document individually in Canvas. In addition, provide the link to the Excel file and to the Word document in OneDrive with your submission. Keep in mind that OneDrive records the version history of the documents to confirm that all team members participated in their creation.
Q1 Microsoft
365 has
improved
engagement for
remote
Participant ID
Company Name
employees.
1 Poplar Lane Tech
Strongly Agree
2 Poplar Lane Tech
Strongly Agree
3 Poplar Lane Tech
Strongly Agree
4 PLT
Neutral
5 Poplar Lane Tech
Strongly Agree
6 Poplar Lane Tech
Strongly Agree
7 Poplar Lane Tech
Strongly Agree
8 Poplar Lane Tech
Agree
9 Poplar Lane Tech
Agree
10 Poplar Ln Tech
Agree
10 Poplar Lane tech
Agree
11 Poplar Lane Tech
Agree
12 Poplar Lane Tech
Disagree
13 Poplar Lane Tech
Agree
14 Poplar lane technologies Agree
15 Poplar Lane Tech
Agree
16 Poplar Lane Tech
Agree
17 Poplar Lane Tech
Agree
18 Poplar Lane Tech
Agree
19 Poplar Lane Tech
Agree
null
Poplar Lane Tech
Agree
21 Poplar Lane Tech
Agree
22 Poplar Lane Tech
Strongly Agree
23 Poplar Lane Tech
Strongly Agree
24 Poplar Lane Tech
Strongly Agree
25 Poplar Lane Tech
Strongly Agree
26 Poplar Lane Tech
Strongly Agree
27 PLT
Strongly Agree
28 PLT
Strongly Agree
29 Poplar Lane TechnologiesStrongly Agree
30 Poplar Lane Tech
Neutral
31 Ace Learning Corp
Disagree
Q2 Teams has
improved
Q3 Teams has
engagement for helped create
on-site teams. time savings.
Agree
Strongly Agree
Agree
Strongly Agree
Agree
Strongly Agree
Agree
Agree
Agree
Strongly Agree
Agree
Strongly Agree
Agree
Strongly Agree
Agree
Agree
Strongly Agree Agree
null
Agree
null
Agree
Strongly Agree Agree
Strongly Agree Agree
Strongly Agree Agree
Strongly Agree Agree
Agree
Strongly Agree
Agree
Agree
Strongly Agree Strongly Agree
Strongly DisagreeStrongly Agree
Strongly Agree Strongly Agree
Strongly Agree Strongly Agree
Neutral
Neutral
Agree
Disagree
Agree
Neutral
Agree
Agree
Agree
Agree
Agree
Agree
Strongly Agree Agree
Strongly Agree Agree
Strongly Agree Agree
Strongly Agree Agree
Strongly Agree Agree
Q4 OneDrive has
helped create
time savings.
Agree
Agree
Agree
Agree
Agree
Agree
Agree
Disagree
Agree
Agree
Agree
Agree
Strongly Agree
Agree
Agree
Agree
Agree
Agree
Agree
Agree
Agree
Agree
Strongly Agree
Strongly Disagree
Strongly Agree
Strongly Agree
Neutral
Agree
Agree
Agree
Agree
Strongly Agree
32 Ace Learning Corp
Neutral
Strongly Agree Agree
Agree
33 Ace Learning Corp
Agree
Neutral
Agree
Agree
34 Ace leaning corporation Agree
Neutral
Agree
Agree
35 Ace Learning Corp
Agree
Neutral
Strongly DisagreeAgree
36 Ace Learning Corp
Agree
Agree
Agree
Agree
37 Ace Learning
Agree
Agree
Agree
Agree
38 Ace Learning Corp
Agree
Agree
Agree
Agree
39 Ace Learning Corp
Agree
Agree
Agree
Strongly Agree
39 Ace Leaning Corp
Agree
Agree
Agree
Strongly Agree
40 Ace Learning Corp
Agree
Disagree
Strongly Agree Strongly Agree
41 ALC
Agree
Agree
Strongly Agree Strongly Agree
42 Ace Learning Corp
Agree
Agree
Strongly Agree Neutral
43 Ace Learning Corp
Agree
Agree
Strongly Agree Agree
44 Ace
Strongly Agree Agree
Agree
Agree
45 Ace Learning
Strongly Agree Agree
Neutral
Agree
46 Ace Learning
Strongly Agree Agree
Agree
Agree
47 Ace Learning
Strongly Agree Strongly Agree Agree
Agree
48 Ace Learning Corp
Strongly Agree Strongly Agree Agree
Strongly Agree
49 Ace Learning Corp
Strongly Agree Strongly Agree Agree
Strongly Agree
50 Ace Learning Corp
Strongly Agree Strongly Agree Agree
Strongly Agree
51 Ace Learning Corp
Strongly Agree Strongly Agree Agree
Strongly Agree
52 Ace Learning Corp
null
Strongly Agree Agree
Strongly Agree
53 Ace Learning Corp
Neutral
Strongly DisagreeAgree
Strongly Agree
54 Ace Leaning Corp
Agree
Strongly Agree Agree
Disagree
55 Ace Learning Corp
Agree
Strongly Agree Agree
Strongly Agree
56 Ace Learning Corp
Agree
Neutral
Disagree
Strongly Agree
57 Ace Learning Corp
Agree
Agree
Agree
Agree
58 Ace Learning Corp
Agree
Agree
Agree
Strongly Agree
59 Ace Learning Corp
Agree
Agree
Agree
Strongly Agree
60 Ace Learning Corp
Strongly Agree Agree
Agree
Strongly Agree
61 ACE Learning
Strongly Agree Agree
Disagree
Neutral
62 Ace Learning Corp
Strongly Agree Agree
Agree
Strongly Agree
63 Ace Learning Corp
Strongly Agree Strongly DisagreeAgree
Strongly Agree
64 Ace Learning Corp
Strongly Agree Agree
Agree
Strongly Agree
65 ACE learning Corp
Neutral
Agree
Agree
Strongly Agree
66 Ace Learning Corp
Strongly Agree Agree
Agree
Agree
67 Ace Learning Corp
Strongly Agree Agree
Strongly Agree Agree
68 ACE Learning Corp
Strongly Agree Agree
Strongly Agree Agree
69 Big Timber ManufacturingStrongly Agree Agree
Disagree
Neutral
70 Big Timber Manu.
Strongly Agree Agree
Strongly Agree Agree
71 Big Timber ManufacturingStrongly Disagree Agree
Strongly Agree Agree
72 Big Timber ManufacturingStrongly Agree Agree
Agree
Agree
73 Big Timber ManufacturingStrongly Agree Agree
Strongly Agree Agree
74 Big Timber ManufacturingNeutral
Agree
Strongly Agree Agree
75 Big Timber ManufacturingAgree
Strongly Agree Strongly Agree Agree
76 Big Timber ManufacturingAgree
Strongly Agree Neutral
Agree
77 Big Timber ManufacturingAgree
Strongly Agree Strongly Agree Agree
78 Big Timber ManufacturingAgree
null
Strongly Agree Disagree
79 Big Timber ManufacturingAgree
Strongly Agree Strongly Agree null
80 Big Timber ManufacturingAgree
Strongly Agree Strongly Agree Strongly Agree
81 Big Timber ManufacturingAgree
Strongly Agree Agree
Strongly Agree
82 Big Timber ManufacturingDisagree
Strongly Agree Agree
Strongly Agree
83 Big Timber ManufacturingAgree
Strongly DisagreeAgree
Strongly Agree
84 BTM
Agree
Strongly Agree Agree
Strongly Agree
85 Big Timber ManufacturingAgree
Strongly Agree Agree
Strongly Agree
86 Big Timber ManufacturingNeutral
Neutral
Agree
Strongly Agree
87 Big Timber ManufacturingAgree
Agree
Agree
Strongly Agree
88 Big Timber ManufacturingAgree
Agree
Agree
Strongly Agree
89 Big Timber ManufacturingAgree
Agree
null
Neutral
90 Big Timber
Agree
Agree
Agree
Agree
91 Big Timber
Agree
Agree
Agree
Agree
92 Big Timber
Neutral
Agree
Agree
Agree
93 Big Timber ManufacturingAgree
Agree
Strongly DisagreeAgree
94 Big Timber ManufacturingAgree
Disagree
Strongly Agree Agree
95 Big Timber ManufacturingAgree
Agree
Strongly Agree Agree
96 Big Timber ManufacturingAgree
Agree
Neutral
Agree
97 Big Timber ManufacturingAgree
Agree
Agree
Agree
98 Big Timber ManufacturingAgree
Disagree
Agree
Strongly Disagree
99 Big Timber ManufacturingStrongly Agree Agree
Agree
Agree
100 Big Timber ManufacturingStrongly Agree Agree
Disagree
Agree
101 Big Timber ManufacturingStrongly Agree Agree
Agree
Agree
102 Big Timber ManufacturingStrongly Agree Agree
Agree
Agree
103 BTM
Strongly Agree Agree
Agree
null
104 BTM
Strongly Agree Strongly Agree Disagree
Agree
105 Big Timber
Strongly Disagree Strongly Agree Agree
Agree
106 Big Timber ManufacturingStrongly Agree Strongly Agree Strongly Agree Agree
107 Big Timber ManufacturingStrongly Agree Strongly Agree Strongly Agree Agree
108 Big Timbre manufacturingStrongly Agree Strongly Agree Strongly Agree Agree
109 Big Timber ManufacturingDisagree
Strongly Agree Strongly Agree Agree
110 Big timber manu.
Strongly Agree Strongly Agree Strongly Agree Agree
111 Big Timber ManufacturingStrongly Agree Strongly Agree Agree
Agree
112 Big Timber ManufacturingAgree
Strongly Agree Agree
Agree
113 Big Timber ManufacturingStrongly Agree Strongly Agree Agree
Strongly Agree
114 Big Timber ManufactruingStrongly Agree Agree
Agree
Agree
115 Big Timber ManufacturingStrongly Agree Agree
Neutral
Agree
116 Big Timber ManufacturingNeutral
Agree
Agree
Agree
117 Bigt Timber
Strongly Agree Agree
Agree
Agree
118 Big Timber ManufacturingStrongly Agree Agree
Agree
Agree
119 Big Timber ManufacturingStrongly Agree Neutral
Agree
Agree
120 Big Timber ManufacturingStrongly Agree Agree
Agree
Agree
Q6 Teams has
Q5 Teams has enabled the
improved the
organization to
efficiency and make better,
effectiveness of more informed
meetings.
decisions.
Agree
Neutral
Agree
Neutral
Agree
Agree
Agree
Strongly Agree
Agree
Strongly Agree
Agree
Disagree
Agree
Strongly Agree
Neutral
Strongly Agree
Agree
Neutral
Agree
Strongly Agree
Agree
Strongly Agree
Agree
Agree
Agree
Agree
Strongly Agree Agree
Strongly Agree Strongly Agree
Strongly Agree Strongly Agree
Strongly Agree Strongly Agree
Agree
Strongly Agree
Strongly Agree Strongly Agree
Strongly Agree Strongly Agree
Disagree
Neutral
Agree
Disagree
Agree
Neutral
Agree
Agree
Agree
Agree
Agree
Agree
Agree
Agree
Agree
Agree
Strongly Agree Agree
Agree
Agree
Agree
Agree
Agree
Neutral
Q8 There is great
value in having
Q10
Q7 Teams has company
Q9 Teams has Microsoft
reduced the information
reduced the
365 has
amount of
accessible
number of
streamlined
travel
through one
meetings each knowledge
needed.
application.
week.
sharing.
Agree
Agree
Disagree
Agree
Agree
Agree
Agree
Strongly Agree
Neutral
Agree
Agree
Strongly Agree
Agree
Agree
Agree
Agree
Agree
Agree
Agree
Strongly Agree
Agree
Agree
Neutral
Strongly Agree
Agree
Agree
Agree
Strongly Agree
Neutral
Neutral
Agree
Neutral
Agree
Agree
Agree
Disagree
Agree
Neutral
Disagree
Neutral
Agree
Neutral
Disagree
Neutral
Agree
Neutral
Agree
Agree
Neutral
Neutral
Agree
Agree
Agree
Strongly Agree Agree
Agree
Agree
Agree
Agree
Agree
Agree
Agree
Agree
null
Agree
Agree
Agree
Agree
Agree
Strongly Agree Agree
Agree
Agree
Strongly Agree Agree
Agree
Agree
Strongly Agree Agree
Agree
Agree
Strongly Agree Strongly DisagreeAgree
Neutral
Neutral
Agree
Agree
Agree
Strongly Agree Agree
Agree
Neutral
Strongly Agree Agree
Agree
Strongly Agree Agree
Agree
Agree
Agree
Agree
Agree
Agree
Agree
Strongly Agree Disagree
Agree
Agree
Strongly Agree Agree
Agree
Agree
Strongly Agree Agree
Strongly Agree
Agree
Agree
Agree
Agree
Agree
Strongly Agree Agree
Agree
Agree
Strongly Agree Strongly Agree Agree
Agree
Agree
Agree
Strongly Agree
Strongly Agree
Strongly Agree
Strongly Agree
Strongly Agree
Strongly Agree
Agree
Agree
Agree
Agree
Agree
Neutral
Agree
Agree
Agree
Agree
Agree
Agree
Agree
Agree
Agree
Agree
Agree
Agree
Agree
Agree
Strongly Agree
Strongly Agree
Strongly Agree
Strongly Agree
Strongly Agree
Strongly Agree
Strongly Agree
Strongly Agree
Disagree
Strongly Agree
Strongly Agree
Agree
Strongly Agree
Strongly Agree
Strongly Agree
Neutral
Strongly Agree
Strongly Agree
Neutral
Agree
Neutral
Strongly Agree Agree
Agree
Strongly Agree Disagree
Neutral
Neutral
Agree
Strongly Agree Neutral
Strongly Agree Agree
Agree
Strongly Agree Agree
Agree
Agree
Agree
Strongly Agree Agree
Strongly Agree Agree
Agree
Strongly Agree Agree
Neutral
Agree
Agree
Strongly Agree Agree
Disagree
Agree
Agree
Neutral
Agree
Neutral
Agree
Agree
Neutral
Agree
Neutral
Agree
Agree
Neutral
Agree
Agree
Strongly Disagree
Agree
Agree
Agree
Agree
Strongly Agree
Neutral
Agree
Agree
Agree
Strongly Agree
Neutral
Agree
Agree
Strongly DisagreeNeutral
Neutral
Agree
Agree
Disagree
Agree
Neutral
Agree
Agree
Agree
Agree
Agree
Agree
Agree
Agree
Agree
Agree
Agree
Agree
Agree
Agree
Agree
Neutral
Strongly Agree Agree
Strongly Agree
Agree
Agree
Strongly Disagree Agree
Agree
Strongly DisagreeAgree
Agree
Agree
Agree
Strongly Agree Agree
Strongly Agree Agree
Agree
Strongly Agree Agree
Neutral
Agree
Neutral
Neutral
Agree
Agree
Agree
Agree
Agree
Agree
Agree
Agree
Agree
Agree
Strongly Disagree
Agree
null
Agree
Agree
Strongly Agree Agree
Agree
Agree
Agree
Strongly Agree Agree
Agree
Agree
Agree
Neutral
Agree
Strongly Agree Agree
null
Agree
Agree
Agree
Agree
Agree
Agree
Agree
Agree
Agree
Agree
Agree
Agree
Agree
Agree
Agree
Agree
Agree
Agree
Neutral
Neutral
Agree
Agree
Agree
Agree
Agree
Agree
Agree
Agree
Agree
Agree
Agree
Agree
Strongly DisagreeAgree
Agree
Disagree
Neutral
Strongly Agree Disagree
Agree
Agree
Strongly Agree Strongly Agree Agree
Agree
Agree
Strongly Agree Neutral
Agree
Agree
Agree
Strongly Agree Agree
Agree
Agree
Strongly Agree Agree
Agree
Strongly Agree
Agree
Agree
Agree
Agree
Strongly Agree
Neutral
Agree
Agree
Agree
Agree
Agree
Agree
Agree
Agree
Agree
Agree
Neutral
Agree
Agree
Agree
Agree
Agree
Strongly Agree Agree
Agree
Agree
Agree
Strongly Agree Disagree
Agree
Agree
Agree
Disagree
Agree
Disagree
Strongly Agree Agree
Agree
Strongly Agree
Strongly Agree Strongly Agree Agree
Strongly Agree
Agree
Strongly Agree Agree
Agree
Agree
Agree
Disagree
Strongly Agree
Strongly DisagreeAgree
Disagree
Strongly Agree
Strongly Agree Agree
Agree
Strongly Agree
Strongly Agree Agree
Agree
Neutral
Neutral
Agree
Agree
Strongly Agree
Agree
Agree
null
Strongly Agree
Agree
Neutral
Agree
Strongly Agree
Agree
Agree
Agree
Strongly Agree
Agree
Agree
Agree
Agree
Agree
Agree
Agree
Agree
Agree
Strongly DisagreeAgree
null
Agree
Strongly Agree Agree
Agree
Disagree
Strongly Agree Agree
Agree
Agree
Neutral
Agree
Agree
Agree
Agree
Strongly Agree Agree
Disagree
Agree
Strongly Agree Agree
Agree
Agree
Disagree
Agree
Agree
Agree
Strongly Agree Agree
Agree
Agree
Strongly Agree Agree
Agree
Agree
Agree
Agree
Agree
Agree
Agree
Agree
Strongly Agree Disagree
Agree
Agree
Strongly Agree Agree
Strongly Agree Agree
Disagree
Agree
Neutral
Agree
Strongly Agree Agree
Strongly Agree Agree
Strongly Agree Agree
Strongly Agree Agree
Agree
Agree
Agree
Agree
Strongly Agree Strongly Agree Strongly Agree Agree
Strongly Agree Agree
Agree
Strongly Agree
Strongly Agree Agree
Agree
Strongly Agree
Neutral
Agree
Agree
Strongly Agree
Strongly Agree Neutral
Agree
Strongly Agree
Strongly Agree Agree
Agree
Strongly Agree
Strongly Agree Agree
Agree
Strongly Agree
Neutral
Agree
Neutral
Strongly Agree
Strongly Agree Agree
Agree
Agree
Strongly Agree Agree
Agree
Agree
Strongly Agree null
Agree
Agree
Agree
Agree
Disagree
Agree
Agree
Agree
Agree
Agree
Agree
Agree
Agree
Agree
Agree
Agree
Agree
Agree
Disagree
Agree
Agree
Strongly Agree
Agree
Strongly Agree
Agree
Disagree
Agree
Strongly Agree
Agree
Strongly Agree
Disagree
Agree
Neutral
Strongly Agree
Agree
Strongly Agree
Agree
Strongly Agree
Agree
Neutral
Strongly DisagreeStrongly Agree
Agree
Strongly Agree
Agree
Strongly Agree
Neutral
Strongly Agree
Agree
Agree
Agree
Agree
Agree
Agree
Strongly Agree Agree
Strongly Agree Agree
Disagree
Disagree
Strongly Agree Agree
Strongly Agree Agree
Agree
Neutral
Strongly Agree Agree
Strongly Agree Agree
Strongly Agree Agree
Neutral
Agree
Strongly Agree Strongly Agree
Strongly Agree Agree
Strongly Agree Agree
Strongly Agree Agree
Agree
Agree
Agree
Strongly Agree
Agree
Agree
null
Agree
Agree
Agree
Agree
Neutral
Agree
Agree
Q11 How much
time (in 5minute
increments) do
you save each
day by
collaborating
with Microsoft
365 tools,
compared with
not having
access to the
tools at all?
ten
15
10
5
120
10
12
10
10
10
10
ten
5
5
5
5
20
0
15
15
15
15
15
15
15
15
20
5
5
5
5
25
15
18
15
10
10
10
ten
10
10
10
30
5
10
10
10
10
10
10
10
0
null
15
15
15
15
15
15
15
16
10
10
10
10
10
10
5
15
0
five
10
10
10
10
ten
10
10
10
10
10
10
10
25
15
15
15
15
15
5
5
ten
0
10
10
10
10
10
15
10
10
8
10
10
10
5
5
5
5
0
25
35
5
5
5
10
10
10
10
10
10
100

Purchase answer to see full
attachment