Market researchers are interested in the coverage boasted by cell phone companie
ID: 3059436 • Letter: M
Question
Market researchers are interested in the coverage boasted by cell phone companies, in particular Verizon and Sprint.They take a sample of 40 regions each provider covers and measure the percent of coverage in that neighborhood. Answer the following questions regarding the data.
1) Use Excel's built in functions (not the data analysis toolpak) to obtain the measures of central tendency for Verizon. Clearly label your work and values.
2) In the column next to each measure obtained in part 1, interpret each value.
3) Repeat 1 for Sprint and put it below your work for Verizon clearly labeling your work and values.
4) Repeat step 2 for Sprint.
5) Without constructing a data display, which data set is more skewed?
6) Calculate the Variance and Standard Deviation for the coverage of Verizon.
7) Calculate the Variance and Standard Deviation for the coverage of Sprint.
8) Based on the data who has better coverage? Explain how you know.
BONUS: Based on the data who is more reliable in their coverage? How do you know?
Sprint: 90 90 90 90 91 91 91 91 92 92 92 93 93 93 93 93 94 94 94 94 94 94 94 94 94 94 95 95 95 95 95 95 95 95 95 95 95 95 95 96
Verizion: 90 90 90 90 91 91 92 92 92 92 92 92 92 92 93 93 93 93 93 93 94 94 94 94 94 94 94 94 95 95 95 95 95 95 95 96 96 96 97 98
Market researchers are interested in the coverage boasted by cell phone companies, in particular Verizon and Sprint.They take a sample of 40 regions each provider covers and measure the percent of coverage in that neighborhood. Answer the following questions regarding the data.
1) Use Excel's built in functions (not the data analysis toolpak) to obtain the measures of central tendency for Verizon. Clearly label your work and values.
2) In the column next to each measure obtained in part 1, interpret each value.
3) Repeat 1 for Sprint and put it below your work for Verizon clearly labeling your work and values.
4) Repeat step 2 for Sprint.
5) Without constructing a data display, which data set is more skewed?
6) Calculate the Variance and Standard Deviation for the coverage of Verizon.
7) Calculate the Variance and Standard Deviation for the coverage of Sprint.
8) Based on the data who has better coverage? Explain how you know.
BONUS: Based on the data who is more reliable in their coverage? How do you know?
Explanation / Answer
Market researchers are interested in the coverage boasted by cell phone companies, in particular Verizon and Sprint.They take a sample of 40 regions each provider covers and measure the percent of coverage in that neighborhood. Answer the following questions regarding the data.
1) Use Excel's built in functions (not the data analysis toolpak) to obtain the measures of central tendency for Verizon. Clearly label your work and values.
2) In the column next to each measure obtained in part 1, interpret each value.
3) Repeat 1 for Sprint and put it below your work for Verizon clearly labeling your work and values.
4) Repeat step 2 for Sprint.
5) Without constructing a data display, which data set is more skewed?
6) Calculate the Variance and Standard Deviation for the coverage of Verizon.
7) Calculate the Variance and Standard Deviation for the coverage of Sprint.
8) Based on the data who has better coverage? Explain how you know.
BONUS: Based on the data who is more reliable in their coverage? How do you know?
Sprint: 90 90 90 90 91 91 91 91 92 92 92 93 93 93 93 93 94 94 94 94 94 94 94 94 94 94 95 95 95 95 95 95 95 95 95 95 95 95 95 96
Verizion: 90 90 90 90 91 91 92 92 92 92 92 92 92 92 93 93 93 93 93 93 94 94 94 94 94 94 94 94 95 95 95 95 95 95 95 96 96 96 97 98
Market researchers are interested in the coverage boasted by cell phone companies, in particular Verizon and Sprint.They take a sample of 40 regions each provider covers and measure the percent of coverage in that neighborhood. Answer the following questions regarding the data.
1) Use Excel's built in functions (not the data analysis toolpak) to obtain the measures of central tendency for Verizon. Clearly label your work and values.
2) In the column next to each measure obtained in part 1, interpret each value.
3) Repeat 1 for Sprint and put it below your work for Verizon clearly labeling your work and values.
4) Repeat step 2 for Sprint.
5) Without constructing a data display, which data set is more skewed?
6) Calculate the Variance and Standard Deviation for the coverage of Verizon.
7) Calculate the Variance and Standard Deviation for the coverage of Sprint.
8) Based on the data who has better coverage? Explain how you know.
BONUS: Based on the data who is more reliable in their coverage? How do you know?
Related Questions
drjack9650@gmail.com
Navigate
Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.