Men hrs./mont hly 34.4 25.8 25.8 34.4 68.8 25.8 34.4 17.2 34.4 68.8 68.8 17.2 25.8 17.2 32.25 17.2 25.8 43 516 43 68.8 25.8 25.8 60.2 34.4 43 43 25.8 34.4 17.2 34.4 68.8 34.4 43 19.35 68.8 32.25 12.9 43 43 38.7 34.4 43 344 25.8 25.8 34.4 25.8 25.8 34.4 60.2 25.8 68.8 34.4 Monthly current fee $700.00 $500.00 $500.00 $600.00 $850.00 $450.00 $550.00 $400.00 $550.00 $1,500.00 $1,600.00 $495.00 $550.00 $500.00 $750.00 $350.00 $600.00 $750.00 $10,000.00 $1,100.00 $900.00 $600.00 $600.00 $1,300.00 $650.00 $1,000.00 $900.00 $500.00 $750.00 $450.00 $750.00 $1,100.00 $575.00 $1,250.00 $475.00 $850.00 $900.00 $475.00 $800.00 $900.00 $700.00 $500.00 $750.00 $6,000.00 $600.00 $550.00 $600.00 $500.00 $650.00 $650.00 $1,900.00 $550.00 $1,000.00 $700.00 Per hour rate with current monthly fee $20.35 $19.38 $19.38 $17.44 $12.35 $17.44 $15.99 $23.26 $15.99 $21.80 $23.26 $28.78 $21.32 $29.07 $23.26 $20.35 $23.26 $17.44 $19.38 $25.58 $13.08 $23.26 $23.26 $21.59 $18.90 $23.26 $20.93 $19.38 $21.80 $26.16 $21.80 $15.99 $16.72 $29.07 $24.55 $12.35 $27.91 $36.82 $18.60 $20.93 $18.09 $14.53 $17.44 $17.44 $23.26 $21.32 $17.44 $19.38 $25.19 $18.90 $31.56 $21.32 $14.53 $20.35 Descriptive Summary Men hrs./monthly Mean Median Mode Minimum Maximum Range Variance Standard Deviation Coeff. of Variation Skewness Kurtosis Count Standard Error 51.4009259259 34.4 25.8 12.9 516 503.1 6142.3900 78.3734 152.47% 5.0789 27.0317 54 10.6653 Monthly current fee 1012.4074074074 650 500 350 10000 9650 2160492.2082 1469.8613 145.18% 5.2299 29.1728 54 200.0228 Per hour rate with current monthly fee 20.9664814815 20.64 23.26 12.35 36.82 24.47 23.1066 4.8069 22.93% 0.7796 1.3306 54 0.6541 Maintenance properties list Discrete variables Anderson Residence Aronson Bailey Becker Bertrand Residence Brooks Tres Brown Residence Buttler Residence Carras Residence Cook residence Coulter Residence Cotton Building Davidson Diller Dodge- jeep Dealer Drybourgh Edson Emmerson Geberts Gordon Residence Hassell Residence Highmark Hudak Residence Hulburd Residence Kuffel Langel Residence Leyva Lodato Loncki McGoldrick Middleton Jamie Nariman Panter Residence Paquelet Residence Penn Pierce Powell Connie Rack Residence Right Honda Right Toyota Sassi Singer 6301 E. Sahuaro Smalley Residence Stewart Residence Taylor Thractenberg Underwood Urich Venarge Maintenance Vicky Residence Walsh Westra Zepeda Residence Ziegler Men Monthly hrs./mont current hly fee Per hour rate with current monthly fee Per hour rate with current monthly fee Frequency Probability 34.4 $700.00 $20.35 12.35 2 0.037 Mean $20.97 25.8 $500.00 $19.38 13.08 1 0.019 Median $20.64 25.8 $500.00 $19.38 14.53 2 0.037 Mode $23.26 34.4 $600.00 $17.44 15.99 3 0.056 Variance $23.11 68.8 $850.00 $12.35 16.72 1 0.019 Standard Deviation 25.8 $450.00 $17.44 17.44 6 0.111 34.4 $550.00 $15.99 18.09 1 0.019 17.2 $400.00 $23.26 18.6 1 0.019 My work: 34.4 $550.00 $15.99 18.9 2 0.037 Descriptive Summary 68.8 $1,500.00 $21.80 19.38 5 0.093 68.8 $1,600.00 $23.26 20.35 3 0.056 17.2 $495.00 $28.78 20.93 2 0.037 Mean 25.8 $550.00 $21.32 21.32 3 0.056 Median 34.4 650 20.64 17.2 $500.00 $29.07 21.59 1 0.019 Mode 25.8 500 23.26 32.25 $750.00 $23.26 21.8 3 0.056 Minimum 12.9 350 12.35 17.2 $350.00 $20.35 23.26 8 0.148 Maximum 516 10000 36.82 25.8 $600.00 $23.26 24.55 1 0.019 Range 503.1 9650 24.47 43 $750.00 $17.44 25.19 1 0.019 Variance 6142.39 516 $10,000.00 $19.38 25.58 1 0.019 Standard Deviation 78.3734 1469.861 4.8069314 $4.81 You have three variables. Where Men hrs./ Monthly cu Per hour ra 51.40093 1012.407 20.966481 2160492 23.106589 43 $1,100.00 $25.58 26.16 1 0.019 Coeff. of Variation 1.524747 1.451848 0.2292674 68.8 $900.00 $13.08 27.91 1 0.019 Skewness 5.078942 25.8 $600.00 $23.26 28.78 1 0.019 Kurtosis 25.8 $600.00 $23.26 29.07 2 0.037 Count 60.2 $1,300.00 $21.59 31.56 1 0.019 Standard Error 34.4 $650.00 $18.90 36.82 1 0.019 43 $1,000.00 $23.26 43 $900.00 $20.93 25.8 $500.00 $19.38 34.4 $750.00 $21.80 17.2 $450.00 $26.16 34.4 $750.00 $21.80 68.8 $1,100.00 $15.99 34.4 $575.00 $16.72 43 $1,250.00 $29.07 19.35 $475.00 $24.55 68.8 $850.00 $12.35 32.25 $900.00 $27.91 12.9 $475.00 $36.82 43 $800.00 $18.60 43 $900.00 $20.93 38.7 $700.00 $18.09 34.4 $500.00 $14.53 43 $750.00 $17.44 344 $6,000.00 $17.44 25.8 $600.00 $23.26 25.8 $550.00 $21.32 34.4 $600.00 $17.44 25.8 $500.00 $19.38 25.8 $650.00 $25.19 34.4 $650.00 $18.90 60.2 $1,900.00 $31.56 25.8 $550.00 $21.32 68.8 $1,000.00 $14.53 34.4 $700.00 $20.35 5.22993 0.7796415 27.0317 29.17283 1.3306216 54 54 54 10.66527 200.0228 0.6541405 e are the probabilities? ate with current monthly fee Count of Discrete variables Monthly current fee Total $350.00 1 $400.00 1 $450.00 2 $475.00 2 $495.00 1 $500.00 6 $550.00 5 $575.00 1 $600.00 6 $650.00 3 $700.00 3 $750.00 5 $800.00 1 $850.00 2 $900.00 4 $1,000.00 2 $1,100.00 2 $1,250.00 1 $1,300.00 1 $1,500.00 1 $1,600.00 1 $1,900.00 1 $6,000.00 1 $10,000.00 1 Grand Total 54 You did not do the probabilities - you could have created one. Paco Perez Maintenance properties list Discrete variables Anderson Residence Aronson Bailey Becker Bertrand Residence Brooks Tres Brown Residence Buttler Residence Carras Residence Cook residence Coulter Residence Cotton Building Davidson Diller Dodge- jeep Dealer Drybourgh Edson Emmerson Geberts Gordon Residence Hassell Residence Highmark Hudak Residence Hulburd Residence Kuffel Langel Residence Leyva Lodato Loncki McGoldrick Middleton Jamie Nariman Panter Residence Paquelet Residence Penn Pierce Powell Connie Rack Residence Right Honda Right Toyota Sassi Singer 6301 E. Sahuaro Smalley Residence Stewart Residence Taylor Thractenberg Underwood Urich Venarge Maintenance Vicky Residence Walsh Westra Zepeda Residence Ziegler Target monthly Men fee at Monthly hrs./mont $25.00 per current hly hr. fee %age difference in target and current per hour rate %age difference in target and current per hour rate Frequency Probability 34.4 $860.00 $700.00 0.66% -2.49% 1 0.019 Mean 0.58% 25.8 $645.00 $500.00 1.12% -0.81% 1 0.019 Median 0.66% 25.8 $645.00 $500.00 1.12% -0.76% 1 0.019 Mode 0.29% 34.4 $860.00 $600.00 1.26% -0.35% 1 0.019 Variance 0.01% 68.8 $1,720.00 $850.00 1.49% -0.33% 1 0.019 Standard Deviation 0.77% 25.8 $645.00 $450.00 1.68% -0.32% 1 0.019 34.4 $860.00 $550.00 1.64% -0.26% 1 0.019 17.2 $430.00 $400.00 0.44% -0.05% 1 0.019 34.4 $860.00 $550.00 1.64% -0.03% 1 0.019 68.8 $1,720.00 $1,500.00 0.21% 0.06% 1 0.019 68.8 $1,720.00 $1,600.00 0.11% 0.10% 1 0.019 17.2 $430.00 $495.00 -0.76% 0.11% 1 0.019 25.8 $645.00 $550.00 0.67% 0.13% 1 0.019 17.2 $430.00 $500.00 -0.81% 0.17% 1 0.019 32.25 $806.25 $750.00 0.23% 0.21% 1 0.019 17.2 $430.00 $350.00 1.33% 0.23% 1 0.019 25.8 $645.00 $600.00 0.29% 0.26% 1 0.019 43 $1,075.00 $750.00 1.01% 0.29% 4 0.074 516 $12,900.00 $10,000.00 0.06% 0.43% 2 0.037 43 $1,075.00 $1,100.00 -0.05% 0.44% 1 0.019 68.8 $1,720.00 $900.00 1.32% 0.45% 2 0.037 25.8 $645.00 $600.00 0.29% 0.66% 2 0.037 25.8 $645.00 $600.00 0.29% 0.67% 3 0.056 60.2 $1,505.00 $1,300.00 0.26% 0.80% 1 0.019 34.4 $860.00 $650.00 0.94% 0.82% 1 0.019 43 $1,075.00 $1,000.00 0.17% 0.94% 2 0.037 43 $1,075.00 $900.00 0.45% 0.99% 1 0.019 25.8 $645.00 $500.00 1.12% 1.01% 2 0.037 34.4 $860.00 $750.00 0.43% 1.05% 1 0.019 17.2 $430.00 $450.00 -0.26% 1.12% 4 0.074 34.4 $860.00 $750.00 0.43% 1.26% 2 0.037 68.8 $1,720.00 $1,100.00 0.82% 1.32% 1 0.019 34.4 $860.00 $575.00 1.44% 1.33% 1 0.019 43 $1,075.00 $1,250.00 -0.33% 1.44% 1 0.019 19.35 $483.75 $475.00 0.10% 1.49% 2 0.037 68.8 $1,720.00 $850.00 1.49% 1.64% 2 0.037 32.25 $806.25 $900.00 -0.32% 1.68% 1 0.019 12.9 $322.50 $475.00 -2.49% 2.09% 1 0.019 43 $1,075.00 $800.00 0.80% 43 $1,075.00 $900.00 0.45% 38.7 $967.50 $700.00 0.99% 34.4 $860.00 $500.00 2.09% 43 $1,075.00 $750.00 1.01% 344 $8,600.00 $6,000.00 0.13% 25.8 $645.00 $600.00 0.29% 25.8 $645.00 $550.00 0.67% 34.4 $860.00 $600.00 1.26% 25.8 $645.00 $500.00 1.12% 25.8 $645.00 $650.00 -0.03% 34.4 $860.00 $650.00 0.94% 60.2 $1,505.00 $1,900.00 -0.35% 25.8 $645.00 $550.00 0.67% 68.8 $1,720.00 $1,000.00 1.05% 34.4 $860.00 $700.00 0.66%