Attribution 4.0 (CC BY 4.0)https://creativecommons.org/licenses/by/4.0/
License information was derived automatically
This article describes a free, open-source collection of templates for the popular Excel (2013, and later versions) spreadsheet program. These templates are spreadsheet files that allow easy and intuitive learning and the implementation of practical examples concerning descriptive statistics, random variables, confidence intervals, and hypothesis testing. Although they are designed to be used with Excel, they can also be employed with other free spreadsheet programs (changing some particular formulas). Moreover, we exploit some possibilities of the ActiveX controls of the Excel Developer Menu to perform interactive Gaussian density charts. Finally, it is important to note that they can be often embedded in a web page, so it is not necessary to employ Excel software for their use. These templates have been designed as a useful tool to teach basic statistics and to carry out data analysis even when the students are not familiar with Excel. Additionally, they can be used as a complement to other analytical software packages. They aim to assist students in learning statistics, within an intuitive working environment. Supplementary materials with the Excel templates are available online.
https://assets.publishing.service.gov.uk/media/670782963b919067bb482f33/fire-statistics-data-tables-fire1121-191023.xlsx">FIRE1121: Staff joining fire authorities, by fire and rescue authority, ethnicity and role (19 October 2023) (MS Excel Spreadsheet, 568 KB)
https://assets.publishing.service.gov.uk/media/652d3b15697260000dccf87a/fire-statistics-data-tables-fire1121-201022.xlsx">FIRE1121: Staff joining fire authorities, by fire and rescue authority, ethnicity and role (20 October 2022) (MS Excel Spreadsheet, 583 KB)
https://assets.publishing.service.gov.uk/media/634e809d8fa8f53463dcb9bb/fire-statistics-data-tables-fire1121-211021.xlsx">FIRE1121: Staff joining fire authorities, by fire and rescue authority, ethnicity and role (21 October 2021) (MS Excel Spreadsheet, 449 KB)
https://assets.publishing.service.gov.uk/media/616d82f28fa8f529840622a0/fire-statistics-data-tables-fire1121-221020.xlsx">FIRE1121: Staff joining fire authorities, by fire and rescue authority, ethnicity and role (22 October 2020) (MS Excel Spreadsheet, 349 KB)
https://assets.publishing.service.gov.uk/media/5f86b4d6d3bf7f633bd5225c/fire-statistics-data-tables-fire1121-311019.xlsx">FIRE1121: Staff joining fire authorities, by fire and rescue authority, ethnicity and role (31 October 2019) (MS Excel Spreadsheet, 253 KB)
https://assets.publishing.service.gov.uk/media/5db712c140f0b637a38efa9b/fire-statistics-data-tables-fire1121-181018.xlsx">FIRE1121: Staff joining fire authorities, by fire and rescue authority, ethnicity and role (18 October 2018) (MS Excel Spreadsheet, 150 KB)
https://assets.publishing.service.gov.uk/media/5bbcccd940f0b6384861138e/fire-statistics-data-tables-fire1121.xlsx">FIRE1121: Staff joining fire authorities, by fire and rescue authority, ethnicity and role (26 October 2017) (MS Excel Spreadsheet, 28.2 KB)
Fire statistics data tables
Fire statistics guidance
Fire statistics
The Home Office has changed the format of the published data tables for a number of areas (asylum and resettlement, entry clearance visas, extensions, citizenship, returns, detention, and sponsorship). These now include summary tables, and more detailed datasets (available on a separate page, link below). A list of all available datasets on a given topic can be found in the ‘Contents’ sheet in the ‘summary’ tables. Information on where to find historic data in the ‘old’ format is in the ‘Notes’ page of the ‘summary’ tables.
The Home Office intends to make these changes in other areas in the coming publications. If you have any feedback, please email MigrationStatsEnquiries@homeoffice.gov.uk.
Immigration system statistics, year ending December 2022
Immigration system statistics quarterly release
Immigration system statistics user guide
Publishing detailed data tables in migration statistics
Policy and legislative changes affecting migration to the UK: timeline
Immigration statistics data archives
https://assets.publishing.service.gov.uk/government/uploads/system/uploads/attachment_data/file/1137644/asylum-summary-dec-2022-tables.ods" class="govuk-link">Asylum and resettlement summary tables, year ending December 2022 (ODS, 90KB)
Detailed asylum and resettlement datasets
https://assets.publishing.service.gov.uk/government/uploads/system/uploads/attachment_data/file/1136906/sponsorship-summary-dec-2022-tables.ods" class="govuk-link">Sponsorship summary tables, year ending December 2022 (ODS, 47KB)
https://assets.publishing.service.gov.uk/government/uploads/system/uploads/attachment_data/file/1135656/visas-summary-dec-2022-tables.ods" class="govuk-link">Entry clearance visas summary tables, year ending December 2022 (ODS, 50KB)
Detailed entry clearance visas datasets
https://assets.publishing.service.gov.uk/government/uploads/system/uploads/attachment_data/file/1136455/passenger-arrivals-admissions-summary-dec-2022-tables.ods" class="govuk-link">Passenger arrivals (admissions) summary tables, year ending December 2022 (ODS, 40KB)
Detailed passengers initially stopped at the border datasets
https://assets.publishing.service.gov.uk/government/uploads/system/uploads/attachment_data/file/1135669/extensions-summary-dec-2022-tables.ods" class="govuk-link">Extensions summary tables, year ending December 2022 (ODS, 28KB)
https://assets.publishing.service.gov.uk/government/uploads/system/uploads/attachment_data/file/1135671/settlement-summary-dec-2022-tables.ods" class="govuk-link">Settlement summary tables, year ending December 2022
https://assets.publishing.service.gov.uk/media/65573baad03a8d001207fafa/fire-statistics-data-tables-fire1004-151222.xlsx">FIRE1004: Number of incidents by 1 minute response time bands, fire type and fire and rescue authority (15 December 2022) (MS Excel Spreadsheet, 2.21 MB)
https://assets.publishing.service.gov.uk/media/6391d9fd8fa8f53bafa725b0/fire-statistics-data-tables-fire1004-030222.xlsx">FIRE1004: Number of incidents by 1 minute response time bands, fire type and fire and rescue authority (3 February 2022) (MS Excel Spreadsheet, 2.15 MB)
https://assets.publishing.service.gov.uk/media/61f3d31fe90e07689cd9a961/fire-statistics-data-tables-fire1004-140121.xlsx">FIRE1004: Number of incidents by 1 minute response time bands, fire type and fire and rescue authority, England (14 January 2021) (MS Excel Spreadsheet, 1.98 MB)
https://assets.publishing.service.gov.uk/media/5ffc4fbde90e0763a28739c5/fire-statistics-data-tables-fire1004-160120.xlsx">FIRE1004: Number of incidents by 1 minute response time bands, fire type and fire and rescue authority, England (16 January 2020) (MS Excel Spreadsheet, 5.92 MB)
https://assets.publishing.service.gov.uk/media/5e15d20fed915d3b15939a83/fire-statistics-data-tables-fire1004-17jan2019.xlsx">FIRE1004: Number of incidents by 5 minute response bands (17 January 2019) (MS Excel Spreadsheet, 2.7 MB)
https://assets.publishing.service.gov.uk/media/5c2f883ce5274a6590040edf/fire-statistics-data-tables-fire1004-25jan2018.xlsx">FIRE1004: Number of incidents by 5 minute response bands (25 January 2018) (MS Excel Spreadsheet, 75.5 KB)
Fire statistics data tables
Fire statistics guidance
Fire statistics
https://dataverse-staging.rdmc.unc.edu/api/datasets/:persistentId/versions/1.0/customlicense?persistentId=hdl:1902.29/CD-10849https://dataverse-staging.rdmc.unc.edu/api/datasets/:persistentId/versions/1.0/customlicense?persistentId=hdl:1902.29/CD-10849
"The Statistical Abstract of the United States, published since 1878, is the standard summary of statistics on the social, political, and economic organization of the United States. It is designed to serve as a convenient volume for statistical reference and as a guide to other statistical publications and sources. The latter function is served by the introductory text to each section, the source note appearing below each table, and Appendix I, which comprises the Guide to Sources of Statisti cs, the Guide to State Statistical Abstracts, and the Guide to Foreign Statistical Abstracts. The Statistical Abstract sections and tables are compiled into one Adobe PDF named StatAbstract2009.pdf. This PDF is bookmarked by section and by table and can be searched using the Acrobat Search feature. The Statistical Abstract on CD-ROM is best viewed using Adobe Acrobat 5, or any subsequent version of Acrobat or Acrobat Reader. The Statistical Abstract tables and the metropolitan areas tables from Appendix II are available as Excel(.xls or .xlw) spreadsheets. In most cases, these spreadsheet files offer the user direct access to more data than are shown either in the publication or Adobe Acrobat. These files usually contain more years of data, more geographic areas, and/or more categories of subjects than those shown in the Acrobat version. The extensive selection of statistics is provided for the United States, with selected data for regions, divisions, states, metropolitan areas, cities, and foreign countries from reports and records of government and private agencies. Software on the disc can be used to perform full-text searches, view official statistics, open tables as Lotus worksheets or Excel workbooks, and link directly to source agencies and organizations for supporting information. Except as indicated, figures are for the United States as presently constituted. Although emphasis in the Statistical Abstract is primarily given to national data, many tables present data for regions and individual states and a smaller number for metropolitan areas and cities.Statistics for the Commonwealth of Puerto Rico and for island areas of the United States are included in many state tables and are supplemented by information in Section 29. Additional information for states, cities, counties, metropolitan areas, and other small units, as well as more historical data are available in various supplements to the Abstract. Statistics in this edition are generally for the most recent year or period available by summer 2006. Each year over 1,400 tables and charts are reviewed and evaluated; new tables and charts of current interest are added, continuing series are updated, and less timely data are condensed or eliminated. Text notes and appendices are revised as appropriate. This year we have introduced 72 new tables covering a wide range of subject areas. These cover a variety of topics including: learning disability for children, people impacted by the hurricanes in the Gulf Coast area, employees with alternative work arrangements, adult computer and Internet users by selected characteristics, North America cruise industry, women- and minority-owned businesses, and the percentage of the adult population considered to be obese. Some of the annually surveyed topics are population; vital statistics; health and nutrition; education; law enforcement, courts and prison; geography and environment; elections; state and local government; federal government finances and employment; national defense and veterans affairs; social insurance and human services; labor force, employment, and earnings; income, expenditures, and wealth; prices; business enterprise; science and technology; agriculture; natural resources; energy; construction and housing; manufactures; domestic trade and services; transportation; information and communication; banking, finance, and insurance; arts, entertainment, and recreation; accommodation, food services, and other services; foreign commerce and aid; outlying areas; and comparative international statistics." Note to Users: This CD is part of a collection located in the Data Archive of the Odum Institute for Research in Social Science, at the University of North Carolina at Chapel Hill. The collection is located in Room 10, Manning Hall. Users may check the CDs out subscribing to the honor system. Items can be checked out for a period of two weeks. Loan forms are located adjacent to the collection.
Attribution 4.0 (CC BY 4.0)https://creativecommons.org/licenses/by/4.0/
License information was derived automatically
This worksheet allows you to see how IRT estimates the ML estimate of theta. Plus in the a and b for an item, as well as the response to each item (correct/incorrect).
Spreadsheet used to calculated hydrograph recession statistical parameters (Minimum, Most Probable Value, and Maximum) for the Stochastic Empirical Loading Dilution Model (SELDM) . The spreadsheet was used in conjunction with the SELDM simulations used in the publication: Stonewall, A.J., and Granato, G.E., 2018, Assessing potential effects of highway and urban runoff on receiving streams in total maximum daily load watersheds in Oregon using the Stochastic Empirical Loading and Dilution Model: U.S. Geological Survey Scientific Investigations Report 2019-5053, 116 p., https://doi.org/10.3133/sir20195053, and after using the Hydrograph.xlsx spreadsheet.
Attribution 4.0 (CC BY 4.0)https://creativecommons.org/licenses/by/4.0/
License information was derived automatically
Demonstration of basic applications of instrumental variable estimation (IVE), with applications of the Durbin-Wu-Hausman (DWH) test as an augmented regression.
As of 2019, nearly 50 percent of Finns had used a spreadsheet software within the last 12 months. During the survey period, 69 percent of respondents aged 16 to 24 years and 35 to 44 years used a spreadsheet software such as Excel in Finland.
The South Florida Water Management District (SFWMD) and the U.S. Geological Survey (USGS) have evaluated projections of future droughts for south Florida based on climate model output from the Multivariate Adaptive Constructed Analogs (MACA) downscaled climate dataset from the Coupled Model Intercomparison Project Phase 5 (CMIP5). The MACA dataset includes both Representative Concentration Pathways 4.5 and 8.5 (RCP4.5 and RCP8.5). A Microsoft Excel workbook is provided which tabulates model drought-evaluation statistics for the period 2056-95 based on drought characteristics derived from climate models downscaled by the MACA method assuming historical-standard stomatal resistance. Model drought-evaluation statistics based on 6-mo. and 12-mo. averaged balance anomaly timeseries are provided for four regions: (1) the entire South Florida Water Management District (SFWMD), (2) the Lower West Coast (LWC) water supply region, (3) the Lower East Coast (LEC) water supply region, and (4) the Okeechobee plus (OKEE+) water supply meta-region consisting of Lake Okeechobee (OKEE), the Lower Kissimmee (LKISS), Upper Kissimmee (UKISS), and Upper East Coast (UEC) water supply regions in the SFWMD. The balance anomaly timeseries are computed as the departure from the long-term monthly means of monthly balances (precipitation - reference evapotranspiration) for the period 1950-2005. Then 6-mo. and 12-mo. moving averages of the balance anomalies are computed and drought-event characteristics (duration, intensity and severity) are derived from the moving-average timeseries. The model drought-evaluation statistics include percentile rank of total future (2056-95) drought severity, percentage change in total future drought severity with respect to the historical period (1950-2005) and its percentile rank, as well as p-values comparing the joint distributions of model historical drought characteristics against those derived from observations, and p-values comparing model future to model historical drought characteristics. The lower the p-value, the more different the compared joint distributions of drought characteristics. P-values smaller than a chosen significance level (typically 0.05–0.1) denote models for which the joint distributions of drought characteristics are statistically significantly different.
FIRE1123: Apprentices by gender, fire and rescue authority and role (17 October 2024)
https://assets.publishing.service.gov.uk/media/67078403080bdf716392f0f4/fire-statistics-data-tables-fire1123-191023.xlsx">FIRE1123: Apprentices by gender, fire and rescue authority and role (19 October 2023) (MS Excel Spreadsheet, 294 KB)
https://assets.publishing.service.gov.uk/media/652d3be1d86b1b00143a4fee/fire-statistics-data-tables-fire1123-201022.xlsx">FIRE1123: Apprentices by gender, fire and rescue authority and role (20 October 2022) (MS Excel Spreadsheet, 623 KB)
https://assets.publishing.service.gov.uk/media/634e8518d3bf7f6183b8578e/fire-statistics-data-tables-fire1123-051121.xlsx">FIRE1123: Apprentices by gender, fire and rescue authority and role (05 November 2021) (MS Excel Spreadsheet, 482 KB)
https://assets.publishing.service.gov.uk/media/61853ae0e90e07197e16666d/fire-statistics-data-tables-fire1123-211021.xlsx">FIRE1123: Apprentices by gender, fire and rescue authority and role (21 October 2021) (MS Excel Spreadsheet, 472 KB)
https://assets.publishing.service.gov.uk/media/616d8411e90e07198018f934/fire-statistics-data-tables-fire1123-221020.xlsx">FIRE1123: Apprentices by gender, fire and rescue authority and role (22 October 2020) (MS Excel Spreadsheet, 352 KB)
https://assets.publishing.service.gov.uk/media/5f86b90ad3bf7f6338536bde/fire-statistics-data-tables-fire1123-311019.xlsx">FIRE1123: Apprentices by gender, fire and rescue authority and role (31 October 2019) (MS Excel Spreadsheet, 159 KB)
Fire statistics data tables
Fire statistics guidance
Fire statistics
https://www.statsndata.org/how-to-orderhttps://www.statsndata.org/how-to-order
The Spreadsheet Software market is a dynamic and essential segment of the broader software industry, facilitating data organization, analysis, and visualization for businesses across various sectors. Traditionally seen as tools for basic calculations, modern spreadsheet applications have evolved into sophisticated p
The latest estimates from the 2010/11 Taking Part adult survey produced by DCMS were released on 30 June 2011 according to the arrangements approved by the UK Statistics Authority.
30 June 2011
**
April 2010 to April 2011
**
National and Regional level data for England.
**
Further analysis of the 2010/11 adult dataset and data for child participation will be published on 18 August 2011.
The latest data from the 2010/11 Taking Part survey provides reliable national estimates of adult engagement with sport, libraries, the arts, heritage and museums & galleries. This release also presents analysis on volunteering and digital participation in our sectors and a look at cycling and swimming proficiency in England. The Taking Part survey is a continuous annual survey of adults and children living in private households in England, and carries the National Statistics badge, meaning that it meets the highest standards of statistical quality.
These spreadsheets contain the data and sample sizes for each sector included in the survey:
The previous Taking Part release was published on 31 March 2011 and can be found online.
This release is published in accordance with the Code of Practice for Official Statistics (2009), as produced by the http://www.statisticsauthority.gov.uk/" class="govuk-link">UK Statistics Authority (UKSA). The UKSA has the overall objective of promoting and safeguarding the production and publication of official statistics that serve the public good. It monitors and reports on all official statistics, and promotes good practice in this area.
The document below contains a list of Ministers and Officials who have received privileged early access to this release of Taking Part data. In line with best practice, the list has been kept to a minimum and those given access for briefing purposes had a maximum of 24 hours.
The responsible statistician for this release is Neil Wilson. For any queries please contact the Taking Part team on 020 7211 6968 or takingpart@culture.gsi.gov.uk.
Information on general practice statistics such as GP type, age group and place of basic qualification. Excel spreadsheet & PDF or GP workforce statistics. Information on general practice statistics such as GP type, age group and place of basic qualification. Excel spreadsheet & PDF or GP workforce statistics.
Attribution 4.0 (CC BY 4.0)https://creativecommons.org/licenses/by/4.0/
License information was derived automatically
Abstract SPEED Stat is a new spreadsheet program for univariate statistical analyses, focused on the dominant profile of agricultural experimentation. The program can perform analysis of variance; tests for normality, homoscedasticity, additivity, outliers; complex contrasts; multiple comparison tests; Scott-Knott's grouping analysis; regression analysis; and others. It has available at speedstatsoftware.wordpress.com.
This file consists of the four original sheets included in the District Profile Report download, as described on the About FY21 Report tab, an additional five sheets created for GIS use and documentation, and an About File tab.The original four sheets are as follows:1. The “District Profile Report” provides a list of statistics for a given school district under seven groupings listed above (A-G). There are six columns of data in this worksheet. The first three columns provide statistics for each data element for the selected district, similar districts average and statewide average. There are three additional columns that enable the user to look at the statistics of three other school districts for comparison. By clicking in the cell below the Comparison Districts 1, 2 and 3 labels, the user can choose three additional school districts to review simultaneously.2. The worksheet labeled “District Data” provides a downloadable file of school district data.3. The worksheet labeled “Similar Districts Data” provides a downloadable file of similar districts averages.4. The worksheet labeled “Statewide Data” provides statewide averages for every statistic in the report.The five new sheets are as follows:1. FY21_Data_Dictionary - contains the abbreviated column names for GIS use and their definitions as found on the original download page. (The link is on the About FY21 Report sheet)2. FY21_Join - contains the District Data formatted for use in a GIS in the following way: the attribute/column titles were abbreviated for use in GIS, column C - UNSDLEA21 was added to facilitate joining to the Census School District geography file, column D - COUNTY was added for geographical filtering purposes, column E - COUNTY_GEOID was added for geographical filtering purposes. All columns from F to BM remain in the same order as the original dataset3. About FY21 Report - contains the report description as found on the original download page. The link to that original download page is also on this sheet.4. Mismatches - contains the school districts where the Census UNSDLEA cannot be derived from the Ohio IRN for quality control purposes5. No Data - contains the school districts that are not in the Profile Report but are in the Census geography data, for a quality control check when performing a join
This file consists of the four original sheets included in the District Profile Report download, as described on the About FY23 Report tab, an additional five sheets created for GIS use and documentation, and an About File tab.The original four sheets are as follows:1. The “District Profile Report” provides a list of statistics for a given school district under seven groupings listed above (A-G). There are six columns of data in this worksheet. The first three columns provide statistics for each data element for the selected district, similar districts average and statewide average. There are three additional columns that enable the user to look at the statistics of three other school districts for comparison. By clicking in the cell below the Comparison Districts 1, 2 and 3 labels, the user can choose three additional school districts to review simultaneously.2. The worksheet labeled “District Data” provides a downloadable file of school district data.3. The worksheet labeled “Similar Districts Data” provides a downloadable file of similar districts averages.4. The worksheet labeled “Statewide Data” provides statewide averages for every statistic in the report.The five new sheets are as follows:1. FY23_Data_Dictionary - contains the abbreviated column names for GIS use and their definitions as found on the original download page. (The link is on the About FY23 Report sheet)2. FY23_Join - contains the District Data formatted for use in a GIS in the following way: the attribute/column titles were abbreviated for use in GIS, column C - UNSDLEA23 was added to facilitate joining to the Census School District geography file, column D - COUNTY was added for geographical filtering purposes, column E - COUNTY_GEOID was added for geographical filtering purposes. All columns from F to BM remain in the same order as the original dataset3. About FY23 Report - contains the report description as found on the original download page. The link to that original download page is also on this sheet.4. Mismatches - contains the school districts where the Census UNSDLEA cannot be derived from the Ohio IRN for quality control purposes5. No Data - contains the school districts that are not in the Profile Report but are in the Census geography data, for a quality control check when performing a join
The level of catches and landings of key quota species are monitored throughout the year through a series of weekly and monthly spreadsheets.
The management of these quotas is through a system of allocation to various fishermen’s producer organisations.
<p class="gem-c-attachment_metadata"><span class="gem-c-attachment_attribute">MS Excel Spreadsheet</span>, <span class="gem-c-attachment_attribute">704 KB</span></p>
<p class="gem-c-attachment_metadata"><span class="gem-c-attachment_attribute">MS Excel Spreadsheet</span>, <span class="gem-c-attachment_attribute">464 KB</span></p>
Attribution 4.0 (CC BY 4.0)https://creativecommons.org/licenses/by/4.0/
License information was derived automatically
In March 2003, banks and selected Registered Financial Corporations (RFCs) began reporting their international assets, liabilities and country exposures to APRA in ARF/RRF 231 International Exposures. This return is the basis of the data provided by Australia to the Bank for International Settlements (BIS) for its International Banking Statistics (IBS) data collection. APRA ceased the RFC data collection after September 2010.
The IBS data are based on the methodology described in the BIS Guide on International Financial Statistics (see http://www.bis.org/statistics/intfinstatsguide.pdf; Part II International banking statistics). Data reported for Australia, and other countries, on the BIS website are expressed in United States dollars (USD).
Data are recorded on an end-quarter basis.
There are two sets of IBS data: locational data, which are used to gauge the role of banks and financial centres in the intermediation of international capital flows; and consolidated data, which can be used to monitor the country risk exposure of national banking systems. Only consolidated data are reported in this statistical table.
Data are shown for a range of countries and regions. Similar data for a selected group of countries are also available in statistical table B13.1.
Country and regional groupings are based on the classification used in the IBS.
Data presented in this statistical table are immediate risk claims (expressed by the BIS as claims on an immediate borrower basis), which cover exposures on an immediate counterparty location basis. Ultimate risk claims are presented in complementary statistical tables B13.2 and B13.2.1, which cover immediate exposures adjusted (via guarantees and other risk transfers) to reflect the location of the ultimate counterparty/risk.
International claims represent cross-border claims in all currencies and foreign offices’ local claims in non-local currencies (which would include, for example, USD claims on New Zealand residents by the New Zealand subsidiary of an Australian-owned bank).
This statistical table contains seven data worksheets. Six present data for countries within each specified region, while the 'Summary' worksheet shows total international claims of the globally consolidated operations of Australian-owned banks for each region, international organisations and unallocated. In each of these worksheets, the data in the last column measures total international claims for the region. Total international claims for each country add to total international claims for the region. However, in some quarters, this cannot be directly verified because data for individual countries and regions have blank entries in order to avoid disclosing confidential bank exposures.
In the 'Summary' worksheet, the positions by region and international organisation, and unallocated are summed to produce a ‘Total’ figure that represents reporting entities’ total international exposures.
Attribution 4.0 (CC BY 4.0)https://creativecommons.org/licenses/by/4.0/
License information was derived automatically
This data file contains one worksheet containing raw data and descriptive statistics regarding static mechanical parameters obtained from force-distance curves of the spider silk fibres using SPIP software, and are described in its manual. The column descriptions for the raw data worksheet are as follows: COLUMN A – Sample Label COLUMN B – Maximum Load Force (Max Ld) COLUMN C – Maximum Pulling Force (Max Pull) COLUMN D – Snap In (Snap In) COLUMN E – Detachment Separation (Detach Sep) COLUMN F – Young’s Modulus (Youngs Mod) COLUMN G – Zero Indentation (Zero Ind) Column H – Dissipated Energy (Energy)
Attribution 4.0 (CC BY 4.0)https://creativecommons.org/licenses/by/4.0/
License information was derived automatically
This article describes a free, open-source collection of templates for the popular Excel (2013, and later versions) spreadsheet program. These templates are spreadsheet files that allow easy and intuitive learning and the implementation of practical examples concerning descriptive statistics, random variables, confidence intervals, and hypothesis testing. Although they are designed to be used with Excel, they can also be employed with other free spreadsheet programs (changing some particular formulas). Moreover, we exploit some possibilities of the ActiveX controls of the Excel Developer Menu to perform interactive Gaussian density charts. Finally, it is important to note that they can be often embedded in a web page, so it is not necessary to employ Excel software for their use. These templates have been designed as a useful tool to teach basic statistics and to carry out data analysis even when the students are not familiar with Excel. Additionally, they can be used as a complement to other analytical software packages. They aim to assist students in learning statistics, within an intuitive working environment. Supplementary materials with the Excel templates are available online.