Question: Pivot Table Data Sheet - Please reply with Excel screen captures that show formulas if possible. I am having trouble creating the pivot table. Movie

Pivot Table Data Sheet - Please reply with Excel screen captures that show formulas if possible. I am having trouble creating the pivot table.

Movie Domestic Gross Rating Type of Movie

Rank (in millions)

1 $999.00 PG-13 Fantasy

2 $988.00 PG Documentary

3 $984.00 PG-13 Thriller

4 $984.00 Unrated SuperHero

5 $981.00 R Fantasy

6 $979.00 PG Fantasy

7 $972.00 PG Fantasy

8 $970.00 PG Family

9 $970.00 PG Romance

10 $957.00 PG-13 Musical

11 $956.00 R Horror

12 $953.00 PG-13 SuperHero

13 $952.00 PG Documentary

14 $951.00 Unrated Sci-Fi

15 $948.00 PG-13 Horror

16 $939.00 G Documentary

17 $934.00 G Family

18 $932.00 Unrated Action

19 $932.00 PG Comedy

20 $930.00 R Horror

21 $907.00 R Western

22 $905.00 PG-13 Romance

23 $904.00 R Sci-Fi

24 $903.00 Unrated Family

25 $898.00 PG-13 Horror

26 $896.00 PG-13 Sci-Fi

27 $882.00 Unrated Cartoon

28 $878.00 Unrated Horror

29 $875.00 Unrated Action

30 $874.00 PG Unknown

31 $873.00 Unrated Horror

32 $860.00 R Thriller

33 $856.00 Unrated Thriller

34 $851.00 R Drama

35 $848.00 R Horror

36 $839.00 PG Thriller

37 $835.00 Unrated Drama

38 $830.00 PG-13 Comedy

39 $829.00 R Horror

40 $824.00 R Horror

41 $821.00 R Comedy

42 $819.00 R Unknown

43 $815.00 R Comedy

44 $809.00 PG-13 Documentary

45 $802.00 PG Thriller

46 $798.00 PG Cartoon

47 $792.00 G Family

48 $787.00 Unrated Family

49 $785.00 PG Musical

50 $775.00 PG-13 Fantasy

51 $770.00 R Comedy

52 $758.00 PG Drama

53 $755.00 PG-13 Family

54 $750.00 PG-13 Western

55 $744.00 PG-13 Thriller

56 $740.00 R Action

57 $736.00 PG-13 Thriller

58 $736.00 R Thriller

59 $731.00 G Cartoon

60 $721.00 PG Sci-Fi

61 $721.00 R Musical

62 $717.00 R Sci-Fi

63 $700.00 G Sci-Fi

64 $692.00 Unrated SuperHero

65 $684.00 PG Fantasy

66 $682.00 PG-13 Fantasy

67 $671.00 PG Action

68 $667.00 G Romance

69 $658.00 Unrated Horror

70 $645.00 R Horror

71 $642.00 G Musical

72 $642.00 G Family

73 $637.00 PG-13 Thriller

74 $637.00 PG-13 Comedy

75 $634.00 PG-13 Horror

76 $632.00 Unrated Horror

77 $629.00 Unrated SuperHero

78 $623.00 R Documentary

79 $623.00 Unrated Romance

80 $620.00 PG-13 SuperHero

81 $615.00 Unrated Sci-Fi

82 $612.00 Unrated Documentary

83 $610.00 PG Cartoon

84 $610.00 Unrated Musical

85 $605.00 PG-13 Action

86 $600.00 G Family

87 $594.00 PG-13 SuperHero

88 $590.00 G Family

89 $589.00 G Family

90 $586.00 R Musical

91 $582.00 R Unknown

92 $581.00 R Drama

93 $571.00 PG-13 Comedy

94 $570.00 G Sci-Fi

95 $564.00 PG Documentary

96 $562.00 PG Unknown

97 $556.00 PG-13 Thriller

98 $545.00 PG-13 Thriller

99 $545.00 R Thriller

100 $531.00 G Family

101 $527.00 R Horror

102 $520.00 G Fantasy

103 $503.00 G Documentary

104 $494.00 G Sci-Fi

105 $494.00 PG-13 Thriller

106 $485.00 PG-13 Thriller

107 $478.00 R Drama

108 $474.00 R Documentary

109 $474.00 PG-13 Horror

110 $470.00 R Romance

111 $453.00 R Horror

112 $449.00 PG Horror

113 $446.00 PG Unknown

114 $445.00 PG Family

115 $434.00 PG Sci-Fi

116 $429.00 PG Family

117 $423.00 R Drama

118 $401.00 G Sci-Fi

119 $398.00 R SuperHero

120 $393.00 G Family

121 $391.00 G Musical

122 $388.00 R Action

123 $387.00 PG Romance

124 $386.00 PG-13 Unknown

125 $381.00 G Romance

126 $380.00 PG Musical

127 $378.00 PG-13 Family

128 $378.00 R Action

129 $376.00 R Sci-Fi

130 $375.00 PG Family

131 $364.00 PG-13 Drama

132 $352.00 PG-13 Horror

133 $335.00 PG-13 SuperHero

134 $335.00 PG-13 Action

135 $332.00 R Documentary

136 $326.00 G Family

137 $321.00 PG-13 SuperHero

138 $317.00 PG-13 SuperHero

139 $313.00 G Romance

140 $306.00 Unrated Fantasy

141 $300.00 PG Cartoon

142 $298.00 PG-13 Thriller

143 $296.00 R Thriller

144 $293.00 G Comedy

145 $284.00 PG Comedy

146 $278.00 G Sci-Fi

147 $269.00 R SuperHero

148 $253.00 R Documentary

149 $253.00 R Cartoon

150 $250.00 PG-13 Action

151 $245.00 R Horror

152 $241.00 R SuperHero

153 $233.00 R Comedy

154 $230.00 R Comedy

155 $228.00 PG-13 Horror

156 $224.00 PG Family

157 $219.00 PG-13 Western

158 $218.00 R Fantasy

159 $216.00 PG-13 Fantasy

160 $202.00 G Romance

161 $202.00 R Action

162 $197.00 PG-13 Documentary

163 $194.00 PG Drama

164 $193.00 PG Action

165 $187.00 PG Action

166 $183.00 PG-13 Cartoon

167 $182.00 G Family

168 $181.00 G Comedy

169 $171.00 PG-13 Comedy

170 $169.00 PG-13 Documentary

171 $167.00 PG-13 Romance

172 $166.00 PG-13 Cartoon

173 $164.00 PG Romance

174 $157.00 R Cartoon

175 $130.00 PG-13 Documentary

176 $129.00 PG Comedy

177 $129.00 G Family

178 $125.00 PG-13 Thriller

179 $106.00 PG-13 Romance

180 $82.00 PG Family

181 $81.00 G Action

182 $79.00 R Horror

183 $79.00 R Romance

184 $78.00 R Cartoon

185 $73.00 G Documentary

186 $70.00 PG-13 Sci-Fi

187 $69.00 PG-13 SuperHero

188 $69.00 G Cartoon

189 $63.00 PG-13 Drama

190 $60.00 R Horror

191 $57.00 PG Documentary

192 $54.00 PG-13 SuperHero

193 $36.00 PG Thriller

194 $30.00 R Romance

195 $26.00 R Fantasy

196 $15.00 G Documentary

197 $14.00 R Action

198 $4.00 R Fantasy

199 $4.00 PG Documentary

200 $1.00 R SuperHero

-Using the data on the Pivot Table Data Sheet above, make a Pivot table showing: 1) The Movie Type, Count of Type, and Sum of Domestic Gross (in millions); columns B and D from the Pivot Table Data Sheet Have three columns:Movie Type, Count of Type, and Sum of Domestic Gross (in millions) Format the Sum of Domestic Gross (in millions) Field using $

-Which type of movie had the highest Domestic Gross Total for 2018?

-Which type of movie had the highest number of films made of that type in 2018?

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer

Step: 1 Unlock blur-text-image

Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock

Step: 3 Unlock

Students Have Also Explored These Related Mathematics Questions!

INTRODUCTION This exercise is comprised of four parts. Part 1 covers automated routines macros in Excel to rearrange and transform data, Part 2 covers Pivot Table: Data Sets Cross-Tabulation and...

This exercise is comprised of four parts. Part 1 covers automated routines macros in Excel to rearrange and transform data, Part 2 covers Pivot Table: Data Sets Cross-Tabulation and Querying in Excel...

please complete the answer sheet using 2016 annual report Financial Statement Analysis Project ANSWER SHEET Name(s): No. Question 1. Who is responsible for the financial statements and maintaining...

BIZ3189 Management Information Systems Take-home Exam 1 The tasks in this exam aim at developing a basic level of understanding on Excel and how you can use it to develop Decision Support Systems....

please answer question 1,2,3,4,5 DA2 Risk For Students(2) (1) QSearch Sheet AutoSave FF Review View DComments Home Insert Draw Page Layout Formulas Data Share _ 4 AY Insert vA A General Calibri...

Hello, Can someone help me do data analysis exercise? Please see the requirement attached. I am looking for high quality work. SAP Lumira desktop (SAP Predictive Analytics) DATA ANALYSIS EXERCISE 2...

I do not know what to do with the following questions. Step 3: Sort and Create Summary Report and Chart A. To create the Sorted Data worksheet, begin by creating a copy of the Condo Sales Data. Once...

During the depression of the 1930s, Ben Jenkins, Sr., a wealthy, expansion-oriented lumberman whose family had been in the lumber business in the southeaster United States for several generations,...

Planning is one of the most important management functions in any business. A front office managers first step in planning should involve determine the departments goals. Planning also includes...

The manufacturer of Ice Melt claims that its product will melt snow and ice at temperatures as low as 0 Fahrenheit. A representative for a large chain of hardware stores is interested in testing this...

a) When we make decisions we often use heuristics Outline and describe the two main heuristics presented in class, and provide examples of each What information do we use when we are utilizing a...

How is the unemployment rate calculated?

On January 2, 2015, Indigo Corporation issued $1,850,000 of 10% bonds at 96 due December 31, 2024. Interest on the bonds is payable annually each December 31. The discount on the bonds is also being...