{"id":1402,"date":"2015-12-16T21:14:43","date_gmt":"2015-12-16T21:14:43","guid":{"rendered":"http:\/\/opentextbc.ca\/introductorybusinessstatistics\/?post_type=back-matter&#038;p=1402"},"modified":"2016-08-30T19:06:30","modified_gmt":"2016-08-30T19:06:30","slug":"appendix-interactive-spreadsheets-editable","status":"publish","type":"back-matter","link":"https:\/\/opentextbc.ca\/introductorybusinessstatistics\/back-matter\/appendix-interactive-spreadsheets-editable\/","title":{"raw":"Appendix: Interactive Spreadsheets - Editable","rendered":"Appendix: Interactive Spreadsheets &#8211; Editable"},"content":{"raw":"The interactive spreadsheets used throughout this book have been locked except for select cells that allow the student and reader to practice specific concepts by entering, deleting, and then re-entering numbers. It was necessary to do this in order to maintain the integrity of the concepts and formulas being presented.\r\n\r\nHowever, because this textbook is covered by an open license, these spreadsheets must also be available in editable form. Unlocked versions of all spreadsheets used in this textbook are listed below by chapter and figure number, and downloadable in the web version of this textbook.\r\n<h2>Chapter 1<\/h2>\r\n<a href=\"https:\/\/opentextbc.ca\/introductorybusinessstatistics\/wp-content\/uploads\/sites\/45\/2016\/08\/Chapter-1_Fig-1.1_Descriptive_Statistics-and-Frequency-Distributions.xlsx\">Figure 1.1 Interactive Excel Template of a Histogram<\/a>\r\n\r\n<a href=\"http:\/\/opentextbc.ca\/introductorybusinessstatistics\/wp-content\/uploads\/sites\/45\/2015\/12\/Chapter-1_Fig-1.2_Variance-and-S.D.xlsx\">Figure 1.2 Interactive Excel Template to Calculate Variance and Standard Deviation<\/a>\r\n<h2>Chapter 2<\/h2>\r\n<a href=\"http:\/\/opentextbc.ca\/introductorybusinessstatistics\/wp-content\/uploads\/sites\/45\/2015\/12\/Chapter-2_Fig-2.1_The-Normal-Distribution.xlsx\">Figure 2.1 Interactive Excel Template for Cumulative Standard Normal Distributions<\/a>\r\n\r\n<a href=\"http:\/\/opentextbc.ca\/introductorybusinessstatistics\/wp-content\/uploads\/sites\/45\/2015\/12\/Chapter-2_Fig-2.2_CLT.xlsx\">Figure 2.2 Interactive Excel Template for Illustrating the Central Limit Theorem<\/a>\r\n\r\n<a href=\"http:\/\/opentextbc.ca\/introductorybusinessstatistics\/wp-content\/uploads\/sites\/45\/2015\/12\/Chapter-2_Fig-2.3_t_Distribution_01.xlsx\">Figure 2.3 Interactive Excel Template of a t-Table<\/a>\r\n<h2>Chapter 3<\/h2>\r\n<a href=\"http:\/\/opentextbc.ca\/introductorybusinessstatistics\/wp-content\/uploads\/sites\/45\/2015\/12\/Chapter-3_Fig-3.1_t_Distribution_01.xlsx\">Figure 3.1 Interactive Excel Template for Determining the t-Values Cut-off Point<\/a>\r\n\r\n<a href=\"http:\/\/opentextbc.ca\/introductorybusinessstatistics\/wp-content\/uploads\/sites\/45\/2015\/12\/Chapter-3_Fig-3.2_Chi_Square-Distribution.xlsx\">Figure 3.2 Interactive Excel Template for Determining the \u03c72 Cut-off Point<\/a>\r\n<h2>Chapter 4<\/h2>\r\n<a href=\"http:\/\/opentextbc.ca\/introductorybusinessstatistics\/wp-content\/uploads\/sites\/45\/2015\/12\/Chapter-4_Fig-4.1_Test-of-Hypothesis.xlsx\">Figure 4.1 Interactive Excel Template for Test of Hypothesis<\/a>\r\n\r\n<a href=\"http:\/\/opentextbc.ca\/introductorybusinessstatistics\/wp-content\/uploads\/sites\/45\/2015\/12\/Chapter-4_Fig-4.2_Chi_Square-Distribution.xlsx\">Figure 4.2 Interactive Excel Template for Determining Chi-Square Cut-off Point<\/a>\r\n<h2>Chapter 5<\/h2>\r\n<a href=\"http:\/\/opentextbc.ca\/introductorybusinessstatistics\/wp-content\/uploads\/sites\/45\/2015\/12\/Chapter-5_Fig-5.1_t_Table.xlsx\">Figure 5.1 Interactive Excel Template for Determining Cut-off Point of a t-Table<\/a>\r\n\r\n<a href=\"http:\/\/opentextbc.ca\/introductorybusinessstatistics\/wp-content\/uploads\/sites\/45\/2015\/12\/Chapter-5_Fig-5.2_Paired_Sample.xlsx\">Figure 5.2 Interactive Excel Template for Paired t-Test<\/a>\r\n<h2>Chapter 6<\/h2>\r\n<a href=\"http:\/\/opentextbc.ca\/introductorybusinessstatistics\/wp-content\/uploads\/sites\/45\/2015\/12\/Chapter-6_Fig-6.1_Table.xlsx\">Figure 6.1 Interactive Excel Template of an F-Table<\/a>\r\n\r\n<a href=\"http:\/\/opentextbc.ca\/introductorybusinessstatistics\/wp-content\/uploads\/sites\/45\/2015\/12\/Chapter-6_Fig-6.2_F_Test.xlsx\">Figure 6.2 Interactive Excel Template for F-Test<\/a>\r\n\r\n<a href=\"http:\/\/opentextbc.ca\/introductorybusinessstatistics\/wp-content\/uploads\/sites\/45\/2015\/12\/Chapter-6_Fig-6.3_ANOVA.xlsx\">Figure 6.3 Interactive Excel Template for One-Way ANOVA<\/a>\r\n<h2>Chapter 7<\/h2>\r\n<a href=\"http:\/\/opentextbc.ca\/introductorybusinessstatistics\/wp-content\/uploads\/sites\/45\/2015\/12\/Chapter-7_Fig-7.1_Mann_U_Test.xlsx\">Figure 7.1 Interactive Excel Template for the Mann-Whitney U-Test<\/a>\r\n<h2>Chapter 8<\/h2>\r\n<a href=\"http:\/\/opentextbc.ca\/introductorybusinessstatistics\/wp-content\/uploads\/sites\/45\/2015\/12\/Chapter-8_Fig-8.4_t_Table.xlsx\">Figure 8.4 Interactive Excel Template for Determining t-Value from the t-Table<\/a>\r\n\r\n<a href=\"http:\/\/opentextbc.ca\/introductorybusinessstatistics\/wp-content\/uploads\/sites\/45\/2015\/12\/Chapter-8_Fig-8.5_F-Table.xlsx\">Figure 8.5 Interactive Excel Template of an F-Table<\/a>\r\n\r\n<a href=\"http:\/\/opentextbc.ca\/introductorybusinessstatistics\/wp-content\/uploads\/sites\/45\/2015\/12\/Chapter-8_Fig-8.6_Simple-Regression.xlsx\">Figure 8.6 Interactive Excel Template for Simple Regression<\/a>\r\n\r\n<a href=\"http:\/\/opentextbc.ca\/introductorybusinessstatistics\/wp-content\/uploads\/sites\/45\/2015\/12\/Chapter-8_Fig-8.8_Multiple-Regression.xlsx\">Figure 8.8 Interactive Excel Template for Multiple Regression Model<\/a>","rendered":"<p>The interactive spreadsheets used throughout this book have been locked except for select cells that allow the student and reader to practice specific concepts by entering, deleting, and then re-entering numbers. It was necessary to do this in order to maintain the integrity of the concepts and formulas being presented.<\/p>\n<p>However, because this textbook is covered by an open license, these spreadsheets must also be available in editable form. Unlocked versions of all spreadsheets used in this textbook are listed below by chapter and figure number, and downloadable in the web version of this textbook.<\/p>\n<h2>Chapter 1<\/h2>\n<p><a href=\"https:\/\/opentextbc.ca\/introductorybusinessstatistics\/wp-content\/uploads\/sites\/45\/2016\/08\/Chapter-1_Fig-1.1_Descriptive_Statistics-and-Frequency-Distributions.xlsx\">Figure 1.1 Interactive Excel Template of a Histogram<\/a><\/p>\n<p><a href=\"http:\/\/opentextbc.ca\/introductorybusinessstatistics\/wp-content\/uploads\/sites\/45\/2015\/12\/Chapter-1_Fig-1.2_Variance-and-S.D.xlsx\">Figure 1.2 Interactive Excel Template to Calculate Variance and Standard Deviation<\/a><\/p>\n<h2>Chapter 2<\/h2>\n<p><a href=\"http:\/\/opentextbc.ca\/introductorybusinessstatistics\/wp-content\/uploads\/sites\/45\/2015\/12\/Chapter-2_Fig-2.1_The-Normal-Distribution.xlsx\">Figure 2.1 Interactive Excel Template for Cumulative Standard Normal Distributions<\/a><\/p>\n<p><a href=\"http:\/\/opentextbc.ca\/introductorybusinessstatistics\/wp-content\/uploads\/sites\/45\/2015\/12\/Chapter-2_Fig-2.2_CLT.xlsx\">Figure 2.2 Interactive Excel Template for Illustrating the Central Limit Theorem<\/a><\/p>\n<p><a href=\"http:\/\/opentextbc.ca\/introductorybusinessstatistics\/wp-content\/uploads\/sites\/45\/2015\/12\/Chapter-2_Fig-2.3_t_Distribution_01.xlsx\">Figure 2.3 Interactive Excel Template of a t-Table<\/a><\/p>\n<h2>Chapter 3<\/h2>\n<p><a href=\"http:\/\/opentextbc.ca\/introductorybusinessstatistics\/wp-content\/uploads\/sites\/45\/2015\/12\/Chapter-3_Fig-3.1_t_Distribution_01.xlsx\">Figure 3.1 Interactive Excel Template for Determining the t-Values Cut-off Point<\/a><\/p>\n<p><a href=\"http:\/\/opentextbc.ca\/introductorybusinessstatistics\/wp-content\/uploads\/sites\/45\/2015\/12\/Chapter-3_Fig-3.2_Chi_Square-Distribution.xlsx\">Figure 3.2 Interactive Excel Template for Determining the \u03c72 Cut-off Point<\/a><\/p>\n<h2>Chapter 4<\/h2>\n<p><a href=\"http:\/\/opentextbc.ca\/introductorybusinessstatistics\/wp-content\/uploads\/sites\/45\/2015\/12\/Chapter-4_Fig-4.1_Test-of-Hypothesis.xlsx\">Figure 4.1 Interactive Excel Template for Test of Hypothesis<\/a><\/p>\n<p><a href=\"http:\/\/opentextbc.ca\/introductorybusinessstatistics\/wp-content\/uploads\/sites\/45\/2015\/12\/Chapter-4_Fig-4.2_Chi_Square-Distribution.xlsx\">Figure 4.2 Interactive Excel Template for Determining Chi-Square Cut-off Point<\/a><\/p>\n<h2>Chapter 5<\/h2>\n<p><a href=\"http:\/\/opentextbc.ca\/introductorybusinessstatistics\/wp-content\/uploads\/sites\/45\/2015\/12\/Chapter-5_Fig-5.1_t_Table.xlsx\">Figure 5.1 Interactive Excel Template for Determining Cut-off Point of a t-Table<\/a><\/p>\n<p><a href=\"http:\/\/opentextbc.ca\/introductorybusinessstatistics\/wp-content\/uploads\/sites\/45\/2015\/12\/Chapter-5_Fig-5.2_Paired_Sample.xlsx\">Figure 5.2 Interactive Excel Template for Paired t-Test<\/a><\/p>\n<h2>Chapter 6<\/h2>\n<p><a href=\"http:\/\/opentextbc.ca\/introductorybusinessstatistics\/wp-content\/uploads\/sites\/45\/2015\/12\/Chapter-6_Fig-6.1_Table.xlsx\">Figure 6.1 Interactive Excel Template of an F-Table<\/a><\/p>\n<p><a href=\"http:\/\/opentextbc.ca\/introductorybusinessstatistics\/wp-content\/uploads\/sites\/45\/2015\/12\/Chapter-6_Fig-6.2_F_Test.xlsx\">Figure 6.2 Interactive Excel Template for F-Test<\/a><\/p>\n<p><a href=\"http:\/\/opentextbc.ca\/introductorybusinessstatistics\/wp-content\/uploads\/sites\/45\/2015\/12\/Chapter-6_Fig-6.3_ANOVA.xlsx\">Figure 6.3 Interactive Excel Template for One-Way ANOVA<\/a><\/p>\n<h2>Chapter 7<\/h2>\n<p><a href=\"http:\/\/opentextbc.ca\/introductorybusinessstatistics\/wp-content\/uploads\/sites\/45\/2015\/12\/Chapter-7_Fig-7.1_Mann_U_Test.xlsx\">Figure 7.1 Interactive Excel Template for the Mann-Whitney U-Test<\/a><\/p>\n<h2>Chapter 8<\/h2>\n<p><a href=\"http:\/\/opentextbc.ca\/introductorybusinessstatistics\/wp-content\/uploads\/sites\/45\/2015\/12\/Chapter-8_Fig-8.4_t_Table.xlsx\">Figure 8.4 Interactive Excel Template for Determining t-Value from the t-Table<\/a><\/p>\n<p><a href=\"http:\/\/opentextbc.ca\/introductorybusinessstatistics\/wp-content\/uploads\/sites\/45\/2015\/12\/Chapter-8_Fig-8.5_F-Table.xlsx\">Figure 8.5 Interactive Excel Template of an F-Table<\/a><\/p>\n<p><a href=\"http:\/\/opentextbc.ca\/introductorybusinessstatistics\/wp-content\/uploads\/sites\/45\/2015\/12\/Chapter-8_Fig-8.6_Simple-Regression.xlsx\">Figure 8.6 Interactive Excel Template for Simple Regression<\/a><\/p>\n<p><a href=\"http:\/\/opentextbc.ca\/introductorybusinessstatistics\/wp-content\/uploads\/sites\/45\/2015\/12\/Chapter-8_Fig-8.8_Multiple-Regression.xlsx\">Figure 8.8 Interactive Excel Template for Multiple Regression Model<\/a><\/p>\n","protected":false},"author":5,"menu_order":1,"template":"","meta":{"pb_show_title":"on","pb_short_title":"","pb_subtitle":"","pb_authors":[],"pb_section_license":""},"back-matter-type":[26],"contributor":[],"license":[],"class_list":["post-1402","back-matter","type-back-matter","status-publish","hentry","back-matter-type-appendix"],"_links":{"self":[{"href":"https:\/\/opentextbc.ca\/introductorybusinessstatistics\/wp-json\/pressbooks\/v2\/back-matter\/1402","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/opentextbc.ca\/introductorybusinessstatistics\/wp-json\/pressbooks\/v2\/back-matter"}],"about":[{"href":"https:\/\/opentextbc.ca\/introductorybusinessstatistics\/wp-json\/wp\/v2\/types\/back-matter"}],"author":[{"embeddable":true,"href":"https:\/\/opentextbc.ca\/introductorybusinessstatistics\/wp-json\/wp\/v2\/users\/5"}],"version-history":[{"count":11,"href":"https:\/\/opentextbc.ca\/introductorybusinessstatistics\/wp-json\/pressbooks\/v2\/back-matter\/1402\/revisions"}],"predecessor-version":[{"id":1500,"href":"https:\/\/opentextbc.ca\/introductorybusinessstatistics\/wp-json\/pressbooks\/v2\/back-matter\/1402\/revisions\/1500"}],"metadata":[{"href":"https:\/\/opentextbc.ca\/introductorybusinessstatistics\/wp-json\/pressbooks\/v2\/back-matter\/1402\/metadata\/"}],"wp:attachment":[{"href":"https:\/\/opentextbc.ca\/introductorybusinessstatistics\/wp-json\/wp\/v2\/media?parent=1402"}],"wp:term":[{"taxonomy":"back-matter-type","embeddable":true,"href":"https:\/\/opentextbc.ca\/introductorybusinessstatistics\/wp-json\/pressbooks\/v2\/back-matter-type?post=1402"},{"taxonomy":"contributor","embeddable":true,"href":"https:\/\/opentextbc.ca\/introductorybusinessstatistics\/wp-json\/wp\/v2\/contributor?post=1402"},{"taxonomy":"license","embeddable":true,"href":"https:\/\/opentextbc.ca\/introductorybusinessstatistics\/wp-json\/wp\/v2\/license?post=1402"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}