Create a Microsoft? Excel? spreadsheet with the two variables from your learning teams dataset.The independent variables are the Internet and the flexibility that people want with his or her Nook or other electronic devices. The dependent variable is the monthly sales for electronic downloads versus sales in the stores or online purchasesAnalyze the data with MegaStat?, StatCrunch?, Microsoft? Excel?or other statistical tool(s), including:(a) Descriptive stats for each numeric variable (b) Histogram for each numeric variable (c) Bar chart for each attribute (non numeric) variable (d) Scatter plot if the data contains two numeric variablesDetermine the appropriate descriptive statistics. (a) For normally distributed data use the mean and standard deviation. (b) For significantly skewed data use the median and interquartile range.Use the Individual Methodology Findings Template to complete the descriptive statistics. Use the Descriptive Statistics and Interpretation Example to develop an interpretation of the descriptive statistics.Format your paper consistent with APA guidelines.Submit both the spreadsheet and the completed Individual Methodology Findings Template.Attachments.Click here to have a similar paper done for you by one of our writers within the set deadline at a discountedAttachmentsUniversity of Phoenix MaterialDescriptive Statistics and Interpretation ExampleInterpretation PhrasesCentral Tendency:Mean = average of a set of dataMedian = half or equal number of data is above and half or equal number of data is below. It is a midpoint in an ordered (sorted) set of data, a physical locationMode = most frequent value in a set of dataDispersion: Standard deviation = variationInterquartile range (IQR) = the middle 50% of the dataRange = the difference between the largest and smallest value of the dataConfidence Interval: (data must be normal) There is 95% confidence that the population average is between _____ and ____ units.Normal or significantly skewed data:MegaStat: Descriptive statistics Normal curve goodness of fit p-valueNormal, p-value > .05Significantly Skewed, p-value < .05Histogram: Eyeball the histogram.Normal data will have a symmetrical or slightly skewed shape.Significantly Skewed shape will have extreme skewnessUse phrase combinations: Normally distributed: Mean and Standard Deviation, Not normally distributed: Median and IQRDescriptive StatisticsBody Weight (Lbs.)Central Tendency:Mean = 149 Lbs.Dispersion:Standard deviation = 30 Lbs.Count:100Min/Max:99 pounds and 234 Lbs.Confidence Interval:144 to 155 Lbs.See the histogram in Appendix A, and descriptive statistics in Appendix B.Age Distribution is not normally distributedCentral Tendency:Median = 36 yearsDispersion:Interquartile Range = 20.5 years / 2 = ñ 10 yearsCount:100Min/Max:18 years and 74 yearsConfidence Interval:Not applicable (data is not normally distributed)See the histogram in Appendix A, and descriptive statistics in Appendix B. A scatter plot is in Appendix C.Education LevelThirteen percent of the subjects have no high school degree while 44% have high school degree. Forty three percent have a college or college graduate degree. See the bar chart in Appendix D.Descriptive Statistics Interpretation Interpretation Body Weight One hundred subjects were randomly selected. Their body weight was observed between 99 and 234 pounds. Their average weight was 149 pounds, with a variation of plus or minus 30 pounds. One half or more were above 149 pounds. There is 95% confidence that the population body weight average is between 144 and 155 pounds.AgeThe data was significantly skewed. One hundred subjects were randomly selected. Their ages were between 18 and 74 years, with a variation of plus or minus 10 years. One half or more subjects were 36 years of age or older. The middle half of the subjects ages fell between 27 and 47 years. The most frequent age was 36 years.APPENDIX ABody Weight and Age HistogramsAPPENDIX BDescriptive Statistics Body Weight and AgeAPPENDIX CScatterplot Body Age versus WeightAPPENDIX DBar Chart Education Level.Click here to have a similar paper done for you by one of our writers within the set deadline at a discounted AttachmentsDescriptive StatisticsNameQNT/561DateInstructors NameDescriptive StatisticsDetermine the appropriate descriptive statistics.Note: If the data was normally distributed, use the mean and standard deviation. If the data was skewed significantly, use the median and interquartile range.Numeric Variable Name1Distribution: State if not normally distributedCentral Tendency:Dispersion:Number:Min/Max:Confidence Interval: (if distribution is normal)Numeric Variable Name2 (if applicable)Distribution: State if not normally distributedCentral Tendency:Dispersion:Number:Min/Max:Confidence Interval: (if distribution is normal)Attribute Variable Name (if applicable)Create a bar chart. Describe the proportions.Descriptive Statistics InterpretationNumeric Variable Name1Describe the variable in laymen terms.Numeric Variable Name2 (if applicable)Describe the variable in laymen terms.Appendix ARaw data used in the analysisFit data to one page.Appendix BCharts and TablesThis part of the paper will include items that are then cited in the body of the paper. Usually, large items are placed here not to distract from reading the paper.Appendix CDescriptive StatisticsThis part of the paper will include descriptive statistics..Click here to have a similar paper done for you by one of our writers within the set deadline at a discountedAttachments Business Research Books and Nooks Part 3: Sampling and Data CollectionQNT 561August 25, 2014Raj Singh, Ph.D.Sampling and Data CollectionSampling and data collection are two key elements in statistical research. It is critical that the plan for sampling includes checks and balances for making sure the data collected is accurately stated. Books and Nooks goal of this research project is to determine if the consumer demand has shifted from primarily reading in a paper format or electronic format. This will enable Books and Nooks to determine if the electronic or paper products should be expanded upon. The basic idea of sampling is that by selecting some of the elements in a population, we may draw conclusions about the entire population (Cooper & Schindler, 2011).The Sampling ElementThe sampling element that will be utilized for this experiment is data mining. Data mining, according to Cooper and Schindler (2011), is pattern extraction from large amounts of data. . . (p. 109). All sales at Books and Nooks are recorded either through the cash register systems in the brick and mortar locations or online through the checkout process of the website. By examining the sales, the number of each, in store and online, can be calculated.The Sample SizeTo determine the sample size, a formula was used. This formula involved a 95% confidence interval, a 5% margin of error, and a population standard deviation of 1. The reason for the mere 1 for the standard deviation is because people either download their purchases or use Books and Nooks brick and mortar stores or their website. With this calculation a sample size of 370 was found. This formula and its results can be found in the Appendix.Method of random samplingA very useful method of random sampling is termed systematic sampling, based on the population on information needed management decided to use the systematic approach method of sampling. The systematic method of sampling is great to use when sampling larger populations. The systematic approach is used when customers are chosen at random but in a systematic way, For instance when checking out at the register or shopping cart on line each 10th customer will be asked to participate in a survey, the survey will ask very specific questions geared towards proving or validating the hypothesis.Population and SizeThe population for this research experiment would be readers, whether they read traditional books or prefer eBooks does not matter. The size needed for proper testing purposes would be based upon a given period of time, perhaps one month, and the number of customers that made purchases during that time period. Target PopulationThe target population for this experiment is readers that shop at Books and Nooks that are between the ages of 13-55. The reason for testing this specific age group is due to the fact that with the introduction of e-readers younger people are more interested in reading than previous generations. Also by using this target population they can help shed light on the consumer demand in the reading purchasers market. If those sampled were customers of competing book stores the information gained would be futile in determining if either of the hypothesis statements are in fact true.Validity and ReliabilityThe study identifies challenges to both validity and reliability, which needs addressing to make the study both valid and reliable. To gain the specific answers, the researcher must word the questionnaire appropriately. By not rewording the research question well, the interview questions can be inadequate. For instance, there is the possibility that the data from the sample can be misleading terminology or present misunderstanding of the questions by the participants. Therefore, the analysis will have an error without rewording parts of the research question.The reliability of the research is mostly on the validity of the entire process. Reliability is the extent to which results are consistent over time and an accurate representation of the total population under study to be reliable. If the results of a study produce a similar method the research instrument is reliable. Validity determines whether the research truly measures that which it was intended to measure or truthfulness of the research results.Data CollectionThe data for this survey will be collected two ways one is by data mining, by pulling and extracting patterns of transactions from sales in-store as well as on-line; management will be able to determine if there is a correlation in the sales of on line purchases and the decline in traditional book sales. Another part of the sampling will be conducted by performing a survey that will be conducted by systematic sampling; by performing a systematic sampling on a large group management will be able to keep the pool of participating individuals random.Privacy ProtectionThe survey results will be stored into an electronic file protected with passwords. Those individuals participating in the survey will not have to disclose any of their personal information such as name and address. The participants identity will remain anonymous and treated with all confidentiality.Survey Questionnaire Do you prefer reading electronic reading material or traditional paper based products such as novels and magazine?In your opinion, will e-readers take the place of traditional style reading in the past?When thinking of your last 10 reading purchases, how may were e-reading products?Do you want to see more e-reading options offered in Books and Nooks?How many reading purchases have you made in the past year?AppendixCalculate the sample size using a 95% confidence level, and a 5% margin of error.1-a= 1-0.95= 0.05=a/2=0.025Za/2 = Z0.025=1.96ME= 5%=0.05n=CI/ ME= 370ReferencesDonald R. Cooper & Pamela S. Schindler (2011); Business Research Methods 11th ed. , McGraw Hill, Irwin..Click here to have a similar paper done for you by one of our writers within the set deadline at a discounted
Use the order calculator below and get started! Contact our live support team for any assistance or inquiry.
[order_calculator]