경영통계학 레포트

목차

1. A frequency and relative frequency distributions for the method of payment.
2. A bar graph or a pie chart for the method of payment.
3. Frequency and relative frequency distributions for the amount spent in each method of payment
4. Histograms and/or stem-and-leaf plots for the amount spent on each method of payment.
5. A crosstabulation of the method payment and amount spent.

본문내용

1. A frequency and relative frequency distributions for the method of payment.

How I made
- For frequency I used “COUNTIF” function. For example frequency for the check’s function is =COUNTIF(C2:C101,E6).
 C2= The first data of the “method of payment”
 C101 = The last data of the “method of payment”
 E6 = the letter “Check” on the table
- For the relative frequency I used dividing function. For example relative frequency for the check is “=F6/F9”.
 F6 = the frequency of the check on the table
 F9 = the total frequency number on the table

2. A bar graph or a pie chart for the method of payment.

How I made
- I dragged the data of frequency on the table with the nominal data, method, as well. And I chose the pie chart graph

참고 자료

없음