Copy and paste the table below into excel and then create a PivotTable in a new
ID: 354801 • Letter: C
Question
Copy and paste the table below into excel and then create a PivotTable in a new worksheet using all of the data.(A1:I301).
-Using the PivotTable functionality to calculate the total number of transactions, the average revenue, and the total policies sold that meet the following criteria: trasactionsfrom Delaware or Pennsylvania for home or auto insurance.
1. How many total transactions were recorded?
2. What is the average revenue per transaction (dollar value)?
3. What is the total quantity of policies sold?
4. In the Pivot Table created, what fields did you filter on? (Type 'Y' to all that apply)
Sales date (Y or N)
State (Y or N)
Insurance type (Y or N)
Number of Polocies(Y or N)
Policy Price (Y or N)
Transaction ID Sales person State Insurance type Sales date Number of policies Policy Price Policy Revenue Policy Commission 62945 Sheriff Woody New York Life 9/24/12 14 $27.45 $384.30 $17.29 62946 Homestar Runner Delaware Fire 8/11/12 8 $197.99 $1,583.92 $71.28 62947 Homestar Runner Delaware Home 5/18/12 6 $359.85 $2,159.10 $97.16 62948 Mike Wasowski Maryland Home 11/16/12 6 $359.85 $2,159.10 $97.16 62949 Robin Hood Delaware Home 10/14/12 4 $359.85 $1,439.40 $64.77 62950 Robin Hood Delaware Health 2/26/12 4 $379.95 $1,519.80 $68.39 62951 Mary Poppins Maryland Health 10/15/12 3 $379.95 $1,139.85 $51.29 62952 Mary Poppins Maryland Home 8/26/12 6 $359.85 $2,159.10 $97.16 62953 Strong Bad Delaware Home 4/21/12 8 $359.85 $2,878.80 $129.55 62954 Jack Sparrow Maryland Auto 6/12/12 8 $110.97 $887.76 $39.95 62955 Sheriff Woody New York Fire 10/6/12 5 $197.99 $989.95 $44.55 62956 Sheriff Woody New York Home 3/22/12 15 $359.85 $5,397.75 $242.90 62957 Sheriff Woody New York Auto 10/6/12 11 $110.97 $1,220.67 $54.93 62958 Doc Hudson New York Fire 8/30/12 6 $197.99 $1,187.94 $53.46 62959 Doc Hudson New York Life 8/30/12 3 $27.45 $82.35 $3.71 62960 Chicken Little New York Home 2/22/12 8 $359.85 $2,878.80 $129.55 62961 Peter Pan Maryland Auto 1/5/12 4 $105.97 $423.88 $19.07 62962 Peter Pan Maryland Life 1/5/12 15 $27.45 $411.75 $18.53 62963 Winnie the Pooh New York Fire 5/17/12 6 $197.99 $1,187.94 $53.46 62964 Winnie the Pooh New York Home 6/11/12 13 $359.85 $4,678.05 $210.51 62965 Winnie the Pooh New York Home 8/17/12 11 $359.85 $3,958.35 $178.13 62966 Winnie the Pooh New York Auto 5/17/12 2 $105.97 $211.94 $9.54 62967 Winnie the Pooh New York Life 5/17/12 12 $27.45 $329.40 $14.82 62968 Robin Hood Delaware Home 8/17/12 8 $359.85 $2,878.80 $129.55 62969 Captain Hook Pennsylvania Fire 4/26/12 5 $197.99 $989.95 $44.55 62970 Captain Hook Pennsylvania Health 9/25/12 2 $379.95 $759.90 $34.20 62971 Captain Hook Pennsylvania Home 2/17/12 10 $359.85 $3,598.50 $161.93 62972 Captain Hook Pennsylvania Auto 4/26/12 3 $105.97 $317.91 $14.31 62973 Captain Hook Pennsylvania Life 4/26/12 9 $27.45 $247.05 $11.12 62974 Prince Charming Delaware Fire 4/1/12 9 $197.99 $1,781.91 $80.19 62975 Prince Charming Delaware Home 8/19/12 3 $359.85 $1,079.55 $48.58 62976 Prince Charming Delaware Life 4/1/12 10 $27.45 $274.50 $12.35 62977 Chicken Little New York Fire 10/5/12 7 $197.99 $1,385.93 $62.37 62978 Chicken Little New York Auto 10/5/12 13 $105.97 $1,377.61 $61.99 62979 Chicken Little New York Life 10/5/12 11 $27.45 $301.95 $13.59 62980 Mary Poppins Maryland Auto 6/6/12 15 $105.97 $1,589.55 $71.53 62981 Mary Poppins Maryland Life 6/6/12 8 $27.45 $219.60 $9.88 62982 Doc Hudson New York Health 9/1/12 5 $379.95 $1,899.75 $85.49 62983 Mary Poppins Maryland Auto 1/11/12 12 $105.97 $1,271.64 $57.22 62984 Doc Hudson New York Health 4/4/12 3 $379.95 $1,139.85 $51.29 62985 Jack Sparrow Maryland Auto 10/10/12 6 $105.97 $635.82 $28.61 62986 Mike Wasowski Maryland Health 2/14/12 12 $379.95 $4,559.40 $205.17 62987 Robin Hood Delaware Health 2/14/12 10 $379.95 $3,799.50 $170.98 62988 Peter Pan Maryland Health 7/6/12 6 $379.95 $2,279.70 $102.59 62989 Doc Hudson New York Fire 9/22/12 6 $197.99 $1,187.94 $53.46 62990 Doc Hudson New York Health 8/10/12 12 $379.95 $4,559.40 $205.17 62991 Doc Hudson New York Health 10/12/12 11 $379.95 $4,179.45 $188.08 62992 Mary Poppins Maryland Auto 12/12/12 12 $105.97 $1,271.64 $57.22 62993 Lightning McQueen Delaware Life 2/28/12 14 $27.45 $384.30 $17.29 62994 Sheriff Woody New York Health 8/11/12 7 $379.95 $2,659.65 $119.68 62995 Lightning McQueen Delaware Health 1/20/12 12 $379.95 $4,559.40 $205.17 62996 Donald Duck Delaware Fire 1/3/12 9 $197.99 $1,781.91 $80.19 62997 Scrooge McDuck Delaware Health 7/29/12 5 $379.95 $1,899.75 $85.49 62998 Scrooge McDuck Delaware Fire 10/14/12 5 $197.99 $989.95 $44.55 62999 Jack Sparrow Maryland Fire 2/26/12 14 $197.99 $2,771.86 $124.73 63000 Jack Sparrow Maryland Health 7/29/12 4 $379.95 $1,519.80 $68.39 63001 Jack Sparrow Maryland Auto 2/26/12 10 $105.97 $1,059.70 $47.69 63002 Mr. Incredible Pennsylvania Health 1/21/12 8 $379.95 $3,039.60 $136.78 63003 Robin Hood Delaware Auto 2/18/12 13 $105.97 $1,377.61 $61.99 63004 Doc Hudson New York Health 1/21/12 9 $379.95 $3,419.55 $153.88 63005 Mike Wasowski Maryland Auto 11/24/12 4 $105.97 $423.88 $19.07 63006 Chicken Little New York Health 5/12/12 8 $379.95 $3,039.60 $136.78 63007 Daffy Duck Pennsylvania Fire 8/31/12 8 $197.99 $1,583.92 $71.28 63008 Daffy Duck Pennsylvania Life 8/31/12 10 $27.45 $274.50 $12.35 63009 Princess Ariel Delaware Health 10/6/12 11 $379.95 $4,179.45 $188.08 63010 Lightning McQueen Delaware Health 6/17/12 9 $379.95 $3,419.55 $153.88 63011 Homestar Runner Delaware Life 12/16/12 5 $27.45 $137.25 $6.18 63012 Mike Wasowski Maryland Fire 1/26/12 12 $197.99 $2,375.88 $106.91 63013 Mike Wasowski Maryland Health 5/17/12 12 $379.95 $4,559.40 $205.17 63014 Minnie Mouse New York Auto 11/15/12 12 $105.97 $1,271.64 $57.22 63015 Mary Poppins Maryland Auto 5/15/12 13 $105.97 $1,377.61 $61.99 63016 Sheriff Woody New York Fire 8/17/12 8 $197.99 $1,583.92 $71.28 63017 Sheriff Woody New York Health 5/17/12 7 $379.95 $2,659.65 $119.68 63018 Sheriff Woody New York Health 3/14/12 7 $379.95 $2,659.65 $119.68 63019 Sheriff Woody New York Auto 8/17/12 5 $105.97 $529.85 $23.84 63020 Sheriff Woody New York Life 8/17/12 8 $27.45 $219.60 $9.88 63021 Prince Charming Maryland Health 4/26/12 8 $379.95 $3,039.60 $136.78 63022 Captain Hook Pennsylvania Health 4/26/12 14 $379.95 $5,319.30 $239.37 63023 Captain Hook Pennsylvania Auto 2/17/12 4 $105.97 $423.88 $19.07 63024 Captain Hook Pennsylvania Life 2/17/12 6 $27.45 $164.70 $7.41 63025 Lightning McQueen Delaware Health 4/1/12 10 $379.95 $3,799.50 $170.98 63026 Princess Jasmine Maryland Auto 5/11/12 14 $105.97 $1,483.58 $66.76 63027 Mary Poppins Maryland Fire 1/8/12 13 $197.99 $2,573.87 $115.82 63028 Mary Poppins Maryland Home 1/8/12 7 $359.85 $2,518.95 $113.35 63029 Mary Poppins Maryland Auto 1/8/12 5 $105.97 $529.85 $23.84 63030 Mary Poppins Maryland Life 1/8/12 10 $27.45 $274.50 $12.35 63031 Peter Pan Maryland Auto 7/27/12 8 $105.97 $847.76 $38.15 63032 Jack Sparrow Maryland Fire 1/6/12 10 $197.99 $1,979.90 $89.10 63033 Princess Ariel Delaware Life 2/27/12 6 $27.45 $164.70 $7.41 63034 Princess Jasmine Maryland Fire 8/8/12 4 $197.99 $791.96 $35.64 63035 Princess Jasmine Maryland Home 8/8/12 14 $359.85 $5,037.90 $226.71 63036 Princess Jasmine Maryland Home 8/8/12 4 $359.85 $1,439.40 $64.77 63037 Donald Duck Delaware Life 9/26/12 5 $27.45 $137.25 $6.18 63038 Daffy Duck Pennsylvania Home 7/20/12 8 $359.85 $2,878.80 $129.55 63039 Daffy Duck Pennsylvania Home 7/20/12 7 $359.85 $2,518.95 $113.35 63040 Daffy Duck Pennsylvania Auto 7/20/12 7 $105.97 $741.79 $33.38 63041 Daffy Duck Pennsylvania Life 7/20/12 6 $27.45 $164.70 $7.41 63042 Mickey Mouse Delaware Home 12/14/12 11 $359.85 $3,958.35 $178.13 63043 Mickey Mouse Delaware Fire 11/19/12 9 $197.99 $1,781.91 $80.19 63044 Mickey Mouse Delaware Home 11/19/12 8 $359.85 $2,878.80 $129.55 63045 Mickey Mouse Delaware Life 11/19/12 9 $27.45 $247.05 $11.12 63046 Cruella De Vil Maryland Fire 2/19/12 13 $197.99 $2,573.87 $115.82 63047 Lightning McQueen Delaware Fire 8/13/12 8 $197.99 $1,583.92 $71.28 63048 Lightning McQueen Delaware Home 8/13/12 7 $359.85 $2,518.95 $113.35 63049 Lightning McQueen Delaware Auto 8/13/12 5 $105.97 $529.85 $23.84 63050 Cruella De Vil Maryland Home 12/17/12 3 $359.85 $1,079.55 $48.58 63051 Daffy Duck Pennsylvania Fire 6/16/12 13 $197.99 $2,573.87 $115.82 63052 Daffy Duck Pennsylvania Home 6/16/12 9 $359.85 $3,238.65 $145.74 63053 Daffy Duck Pennsylvania Home 6/16/12 5 $359.85 $1,799.25 $80.97 63054 Daffy Duck Pennsylvania Auto 6/16/12 2 $105.97 $211.94 $9.54 63055 Mr. Incredible Pennsylvania Auto 6/29/12 6 $105.97 $635.82 $28.61 63056 Mr. Incredible Pennsylvania Life 6/29/12 16 $27.45 $439.20 $19.76 63057 Mary Poppins Maryland Fire 10/13/12 8 $197.99 $1,583.92 $71.28 63058 Doc Hudson New York Auto 1/25/12 10 $105.97 $1,059.70 $47.69 63059 Prince Charming Maryland Home 7/18/12 13 $359.85 $4,678.05 $210.51 63060 Minnie Mouse New York Home 8/16/12 13 $359.85 $4,678.05 $210.51 63061 Jiminy Cricket Delaware Life 1/10/12 10 $27.45 $274.50 $12.35 63062 Snow White Maryland Home 2/16/12 9 $359.85 $3,238.65 $145.74 63063 Mike Wasowski Maryland Home 10/9/12 5 $359.85 $1,799.25 $80.97 63064 Mike Wasowski Maryland Auto 10/9/12 7 $105.97 $741.79 $33.38 63065 Mike Wasowski Maryland Life 10/9/12 6 $27.45 $164.70 $7.41 63066 Doc Hudson New York Fire 6/15/12 10 $197.99 $1,979.90 $89.10 63067 Doc Hudson New York Home 6/15/12 7 $359.85 $2,518.95 $113.35 63068 Mary Poppins Maryland Home 9/27/12 9 $359.85 $3,238.65 $145.74 63069 Sheriff Woody New York Home 12/15/12 6 $359.85 $2,159.10 $97.16 63070 Mike Wasowski Maryland Home 3/28/12 11 $359.85 $3,958.35 $178.13 63071 Sheriff Woody New York Fire 6/13/12 8 $197.99 $1,583.92 $71.28 63072 Robin Hood Delaware Home 2/24/12 4 $359.85 $1,439.40 $64.77 63073 Robin Hood Delaware Auto 2/24/12 15 $105.97 $1,589.55 $71.53 63074 Robin Hood Delaware Life 2/24/12 8 $27.45 $219.60 $9.88 63075 Princess Ariel Delaware Auto 7/19/12 10 $105.97 $1,059.70 $47.69 63076 Prince Charming Maryland Auto 9/19/12 3 $105.97 $317.91 $14.31 63077 Daffy Duck Pennsylvania Home 2/2/12 6 $359.85 $2,159.10 $97.16 63078 Daffy Duck Pennsylvania Home 2/2/12 4 $359.85 $1,439.40 $64.77 63079 Daffy Duck Pennsylvania Auto 2/2/12 12 $105.97 $1,271.64 $57.22 63080 Mike Wasowski Maryland Auto 1/31/12 5 $105.97 $529.85 $23.84 63081 Chicken Little New York Home 1/30/12 2 $359.85 $719.70 $32.39 63082 Scrooge McDuck Delaware Fire 3/27/12 7 $197.99 $1,385.93 $62.37 63083 Homestar Runner Delaware Fire 7/25/12 10 $197.99 $1,979.90 $89.10 63084 Homestar Runner Delaware Life 7/25/12 5 $27.45 $137.25 $6.18 63085 Mike Wasowski Maryland Home 8/29/12 4 $359.85 $1,439.40 $64.77 63086 Cruella De Vil Maryland Home 12/11/12 15 $359.85 $5,397.75 $242.90 63087 Princess Ariel Delaware Home 4/27/12 7 $359.85 $2,518.95 $113.35 63088 Princess Ariel Delaware Home 4/27/12 11 $359.85 $3,958.35 $178.13 63089 Princess Ariel Delaware Auto 4/27/12 6 $105.97 $635.82 $28.61 63090 Princess Ariel Delaware Life 4/27/12 14 $27.45 $384.30 $17.29 63091 Donald Duck Delaware Fire 6/8/12 8 $197.99 $1,583.92 $71.28 63092 Chicken Little New York Life 3/7/12 11 $27.45 $301.95 $13.59 63093 Jack Sparrow Maryland Auto 4/29/12 12 $105.97 $1,271.64 $57.22 63094 Snow White Maryland Life 4/3/12 9 $27.45 $247.05 $11.12 63095 Princess Jasmine Maryland Fire 12/10/12 9 $197.99 $1,781.91 $80.19 63096 Jack Sparrow Maryland Home 10/11/12 10 $359.85 $3,598.50 $161.93 63097 Princess Ariel Delaware Life 7/24/12 3 $27.45 $82.35 $3.71 63098 Minnie Mouse New York Fire 3/10/12 11 $197.99 $2,177.89 $98.01 63099 Minnie Mouse New York Home 3/10/12 9 $359.85 $3,238.65 $145.74 63100 Minnie Mouse New York Auto 3/10/12 5 $105.97 $529.85 $23.84 63101 Doc Hudson New York Fire 8/15/12 7 $197.99 $1,385.93 $62.37 63102 Mike Wasowski Maryland Fire 6/19/12 14 $197.99 $2,771.86 $124.73 63103 Mike Wasowski Maryland Home 6/19/12 11 $359.85 $3,958.35 $178.13 63104 Mike Wasowski Maryland Home 6/19/12 9 $359.85 $3,238.65 $145.74 63105 Mike Wasowski Maryland Life 6/19/12 13 $27.45 $356.85 $16.06 63106 Donald Duck Delaware Home 4/20/12 7 $359.85 $2,518.95 $113.35 63107 Donald Duck Delaware Home 4/20/12 9 $359.85 $3,238.65 $145.74 63108 Donald Duck Delaware Auto 4/20/12 16 $105.97 $1,695.52 $76.30 63109 Donald Duck Delaware Life 4/20/12 5 $27.45 $137.25 $6.18 63110 Mr. Incredible Pennsylvania Fire 8/9/12 15 $197.99 $2,969.85 $133.64 63111 Homestar Runner Delaware Home 12/18/12 9 $359.85 $3,238.65 $145.74 63112 Strong Bad Delaware Home 6/18/12 8 $359.85 $2,878.80 $129.55 63113 Doc Hudson New York Life 3/6/12 7 $27.45 $192.15 $8.65 63114 Scrooge McDuck Delaware Life 7/4/12 7 $27.45 $192.15 $8.65 63115 Scrooge McDuck Delaware Fire 7/4/12 2 $197.99 $395.98 $17.82 63116 Strong Bad Delaware Life 7/3/12 11 $27.45 $301.95 $13.59 63117 Prince Charming Maryland Fire 1/27/12 10 $197.99 $1,979.90 $89.10 63118 Prince Charming Maryland Home 1/27/12 4 $359.85 $1,439.40 $64.77 63119 Prince Charming Maryland Home 1/27/12 11 $359.85 $3,958.35 $178.13 63120 Jack Sparrow Maryland Life 1/28/12 9 $27.45 $247.05 $11.12 63121 Mike Wasowski Maryland Fire 9/21/12 9 $197.99 $1,781.91 $80.19 63122 Daffy Duck Pennsylvania Fire 2/23/12 5 $197.99 $989.95 $44.55 63123 Daffy Duck Pennsylvania Home 2/23/12 4 $359.85 $1,439.40 $64.77 63124 Daffy Duck Pennsylvania Home 2/23/12 12 $359.85 $4,318.20 $194.32 63125 Daffy Duck Pennsylvania Auto 2/23/12 9 $105.97 $953.73 $42.92 63126 Daffy Duck Pennsylvania Life 2/23/12 6 $27.45 $164.70 $7.41 63127 Chicken Little New York Life 2/15/12 11 $27.45 $301.95 $13.59 63128 Snow White Maryland Fire 8/14/12 11 $197.99 $2,177.89 $98.01 63129 Sheriff Woody New York Home 3/23/12 5 $359.85 $1,799.25 $80.97 63130 Robin Hood Delaware Fire 11/21/12 3 $197.99 $593.97 $26.73 63131 Doc Hudson New York Home 8/28/12 12 $359.85 $4,318.20 $194.32 63132 Mickey Mouse Delaware Fire 7/2/12 7 $197.99 $1,385.93 $62.37 63133 Peter Pan Maryland Home 4/25/12 6 $359.85 $2,159.10 $97.16 63134 Peter Pan Maryland Life 4/25/12 9 $27.45 $247.05 $11.12 63135 Sheriff Woody New York Fire 2/1/12 16 $197.99 $3,167.84 $142.55 63136 Sheriff Woody New York Home 2/1/12 8 $359.85 $2,878.80 $129.55 63137 Sheriff Woody New York Auto 2/1/12 10 $105.97 $1,059.70 $47.69 63138 Sheriff Woody New York Life 2/1/12 5 $27.45 $137.25 $6.18 63139 Donald Duck Delaware Life 5/16/12 3 $27.45 $82.35 $3.71 63140 Sheriff Woody New York Fire 2/25/12 10 $197.99 $1,979.90 $89.10 63141 Chicken Little New York Fire 6/7/12 9 $197.99 $1,781.91 $80.19 63142 Cruella De Vil Maryland Fire 7/5/12 12 $197.99 $2,375.88 $106.91 63143 Mr. Incredible Pennsylvania Home 6/14/12 8 $359.85 $2,878.80 $129.55 63144 Mr. Incredible Pennsylvania Home 6/14/12 15 $359.85 $5,397.75 $242.90 63145 Doc Hudson New York Fire 1/24/12 11 $197.99 $2,177.89 $98.01 63146 Doc Hudson New York Home 1/24/12 7 $359.85 $2,518.95 $113.35 63147 Doc Hudson New York Health 1/24/12 6 $379.95 $2,279.70 $102.59 63148 Doc Hudson New York Auto 1/24/12 10 $105.97 $1,059.70 $47.69 63149 Donald Duck Delaware Fire 4/28/12 14 $197.99 $2,771.86 $124.73 63150 Mike Wasowski Maryland Health 4/2/12 11 $379.95 $4,179.45 $188.08 63151 Lightning McQueen Delaware Fire 9/18/12 9 $197.99 $1,781.91 $80.19 63152 Strong Bad Delaware Fire 3/11/12 10 $197.99 $1,979.90 $89.10 63153 Strong Bad Delaware Health 3/11/12 10 $379.95 $3,799.50 $170.98 63154 Strong Bad Delaware Auto 2/21/12 9 $105.97 $953.73 $42.92 63155 Mike Wasowski Maryland Life 6/10/12 6 $27.45 $164.70 $7.41 63156 Jack Sparrow Maryland Fire 3/26/12 13 $197.99 $2,573.87 $115.82 63157 Captain Hook Pennsylvania Fire 7/7/12 4 $197.99 $791.96 $35.64 63158 Captain Hook Pennsylvania Life 7/7/12 6 $27.45 $164.70 $7.41 63159 Captain Hook Pennsylvania Health 7/7/12 5 $379.95 $1,899.75 $85.49 63160 Captain Hook Pennsylvania Auto 7/7/12 7 $105.97 $741.79 $33.38 63161 Doc Hudson New York Life 7/23/12 10 $27.45 $274.50 $12.35 63162 Sheriff Woody New York Auto 2/3/12 9 $105.97 $953.73 $42.92 63163 Sheriff Woody New York Fire 3/24/12 11 $197.99 $2,177.89 $98.01 63164 Sheriff Woody New York Health 3/24/12 2 $379.95 $759.90 $34.20 63165 Sheriff Woody New York Life 3/24/12 14 $27.45 $384.30 $17.29 63166 Jack Sparrow Maryland Fire 2/29/12 1 $197.99 $197.99 $8.91 63167 Jack Sparrow Maryland Health 2/29/12 10 $379.95 $3,799.50 $170.98 63168 Jack Sparrow Maryland Auto 2/29/12 14 $105.97 $1,483.58 $66.76 63169 Jack Sparrow Maryland Life 2/29/12 8 $27.45 $219.60 $9.88 63170 Doc Hudson New York Life 2/20/12 7 $27.45 $192.15 $8.65 63171 Mr. Incredible Pennsylvania Health 1/23/12 5 $379.95 $1,899.75 $85.49 63172 Princess Jasmine Maryland Health 9/23/12 4 $379.95 $1,519.80 $68.39 63173 Donald Duck Delaware Fire 9/2/12 5 $197.99 $989.95 $44.55 63174 Snow White Maryland Auto 10/7/12 12 $105.97 $1,271.64 $57.22 63175 Mary Poppins Maryland Fire 3/13/12 10 $197.99 $1,979.90 $89.10 63176 Peter Pan Maryland Health 6/9/12 8 $379.95 $3,039.60 $136.78 63177 Lightning McQueen Delaware Auto 5/14/12 14 $105.97 $1,483.58 $66.76 63178 Jack Sparrow Maryland Fire 8/25/12 13 $197.99 $2,573.87 $115.82 63179 Mr. Incredible Pennsylvania Health 3/15/12 11 $379.95 $4,179.45 $188.08 63180 Mr. Incredible Pennsylvania Life 3/15/12 5 $27.45 $137.25 $6.18 63181 Mr. Incredible Pennsylvania Health 3/8/12 6 $379.95 $2,279.70 $102.59 63182 Cruella De Vil Maryland Fire 8/27/12 13 $197.99 $2,573.87 $115.82 63183 Princess Ariel Delaware Health 7/28/12 9 $379.95 $3,419.55 $153.88 63184 Princess Jasmine Maryland Fire 4/24/12 2 $197.99 $395.98 $17.82 63185 Princess Jasmine Maryland Auto 4/24/12 8 $105.97 $847.76 $38.15 63186 Princess Jasmine Maryland Life 4/24/12 7 $27.45 $192.15 $8.65 63187 Princess Ariel Delaware Life 3/30/12 14 $27.45 $384.30 $17.29 63188 Jack Sparrow Maryland Auto 10/8/12 6 $105.97 $635.82 $28.61 63189 Jiminy Cricket Delaware Fire 3/25/12 7 $197.99 $1,385.93 $62.37 63190 Jiminy Cricket Delaware Health 3/25/12 1 $379.95 $379.95 $17.10 63191 Jiminy Cricket Delaware Auto 3/25/12 12 $105.97 $1,271.64 $57.22 63192 Jiminy Cricket Delaware Life 3/25/12 5 $27.45 $137.25 $6.18 63193 Homestar Runner Delaware Life 7/1/12 5 $27.45 $137.25 $6.18 63194 Homestar Runner Delaware Health 9/20/12 10 $379.95 $3,799.50 $170.98 63195 Homestar Runner Delaware Auto 9/20/12 10 $105.97 $1,059.70 $47.69 63196 Homestar Runner Delaware Life 9/20/12 10 $27.45 $274.50 $12.35 63197 Strong Bad Delaware Fire 11/22/12 12 $197.99 $2,375.88 $106.91 63198 Mike Wasowski Maryland Health 4/22/12 6 $379.95 $2,279.70 $102.59 63199 Mickey Mouse Delaware Health 6/5/12 5 $379.95 $1,899.75 $85.49 63200 Mike Wasowski Maryland Fire 4/23/12 3 $197.99 $593.97 $26.73 63201 Mike Wasowski Maryland Health 4/23/12 13 $379.95 $4,939.35 $222.27 63202 Mike Wasowski Maryland Auto 4/23/12 5 $105.97 $529.85 $23.84 63203 Mike Wasowski Maryland Life 4/23/12 7 $27.45 $192.15 $8.65 63204 Donald Duck Delaware Health 7/8/12 5 $379.95 $1,899.75 $85.49 63205 Donald Duck Delaware Auto 7/8/12 9 $105.97 $953.73 $42.92 63206 Donald Duck Delaware Life 7/8/12 10 $27.45 $274.50 $12.35 63207 Prince Charming Maryland Health 7/22/12 14 $379.95 $5,319.30 $239.37 63208 Snow White Maryland Health 5/10/12 11 $379.95 $4,179.45 $188.08 63209 Chicken Little New York Fire 11/17/12 13 $197.99 $2,573.87 $115.82 63210 Chicken Little New York Home 11/17/12 9 $359.85 $3,238.65 $145.74 63211 Chicken Little New York Health 11/17/12 7 $379.95 $2,659.65 $119.68 63212 Chicken Little New York Auto 11/17/12 8 $105.97 $847.76 $38.15 63213 Mickey Mouse Delaware Health 8/12/12 7 $379.95 $2,659.65 $119.68 63214 Mary Poppins Maryland Health 3/12/12 4 $379.95 $1,519.80 $68.39 63215 Mary Poppins Maryland Health 3/29/12 15 $379.95 $5,699.25 $256.47 63216 Mary Poppins Maryland Auto 3/29/12 6 $105.97 $635.82 $28.61 63217 Mary Poppins Maryland Life 3/29/12 4 $27.45 $109.80 $4.94 63218 Mr. Incredible Pennsylvania Health 1/22/12 9 $379.95 $3,419.55 $153.88 63219 Mary Poppins Maryland Health 7/21/12 11 $379.95 $4,179.45 $188.08 63220 Homestar Runner Delaware Auto 11/20/12 9 $105.97 $953.73 $42.92 63221 Sheriff Woody New York Health 5/13/12 9 $379.95 $3,419.55 $153.88 63222 Lightning McQueen Delaware Fire 8/18/12 6 $197.99 $1,187.94 $53.46 63223 Lightning McQueen Delaware Auto 8/18/12 13 $105.97 $1,377.61 $61.99 63224 Lightning McQueen Delaware Health 8/18/12 14 $379.95 $5,319.30 $239.37 63225 Strong Bad Delaware Fire 7/26/12 8 $197.99 $1,583.92 $71.28 63226 Strong Bad Delaware Health 7/26/12 12 $379.95 $4,559.40 $205.17 63227 Strong Bad Delaware Life 7/26/12 10 $27.45 $274.50 $12.35 63228 Homestar Runner Delaware Health 1/4/12 8 $379.95 $3,039.60 $136.78 63229 Homestar Runner Delaware Auto 1/4/12 16 $105.97 $1,695.52 $76.30 63230 Peter Pan Maryland Fire 12/13/12 6 $197.99 $1,187.94 $53.46 63231 Peter Pan Maryland Auto 12/13/12 10 $105.97 $1,059.70 $47.69 63232 Chicken Little New York Home 11/23/12 7 $359.85 $2,518.95 $113.35 63233 Winnie the Pooh New York Auto 1/7/12 5 $105.97 $529.85 $23.84 63234 Snow White Maryland Fire 4/4/12 4 $197.99 $791.96 $35.64 63235 Snow White Maryland Home 11/18/12 14 $359.85 $5,037.90 $226.71 63236 Snow White Maryland Auto 4/4/12 14 $105.97 $1,483.58 $66.76 63237 Snow White Maryland Life 4/4/12 14 $27.45 $384.30 $17.29 63238 Cruella De Vil Maryland Fire 2/14/12 5 $197.99 $989.95 $44.55 63239 Cruella De Vil Maryland Home 6/30/12 7 $359.85 $2,518.95 $113.35 63240 Cruella De Vil Maryland Home 3/31/12 10 $359.85 $3,598.50 $161.93 63241 Cruella De Vil Maryland Life 2/14/12 13 $27.45 $356.85 $16.06 63242 Homestar Runner Delaware Home 3/9/12 10 $359.85 $3,598.50 $161.93 63243 Mary Poppins Maryland Home 9/22/12 8 $359.85 $2,878.80 $129.55 63244 Princess Ariel Delaware Home 9/22/12 14 $359.85 $5,037.90 $226.71Explanation / Answer
1. How many total transactions were recorded? 130 Transactions (Delaware - 89 , PA - 41 )
2. What is the average revenue per transaction (dollar value)? Total - 225754.2$. Avg Rev -1736.571$ ( 130 transactions
3. What is the total quantity of policies sold?
Pennsylvania - Home and Auto Insurance - 138 ( 88 - Home & 50 Auto )
Delaware - Home and Auto Insurance - 291 ( 134 - Home & 157 - Auto )
4. In the Pivot Table created, what fields did you filter on? (Type 'Y' to all that apply)
Sales date (Y or N) N
State (Y or N) Y
Insurance type (Y or N) Y
Number of Polocies(Y or N) Y
Policy Price (Y or N) N